Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Does a view not define a composite type? - Mailing list pgsql-general

From Guyren Howe
Subject Re: [GENERAL] Does a view not define a composite type?
Date
Msg-id 3DD3B30E-0EE1-4AA7-A1EA-99F4B7830484@gmail.com
Whole thread Raw
In response to [GENERAL] Does a view not define a composite type?  (Guyren Howe <guyren@gmail.com>)
Responses Re: [GENERAL] Does a view not define a composite type?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view

On Apr 23, 2017, at 10:12 , Guyren Howe <guyren@gmail.com> wrote:

I have a view: “reporting_helpers.customers_by_state_ranked"

I try to define a function with this signature:

CREATE OR REPLACE FUNCTION reporting.formatted_cust_by_state_bold(c "reporting_helpers.customers_by_state_ranked")
    RETURNS "reporting_helpers.customers_by_state_ranked"

I am told “ERROR: type reporting_helpers.customers_by_state_ranked does not exist”

I am confused.

nm; it appears that the quotes were mucking things up.

pgsql-general by date:

Previous
From: Brett Delle Grazie
Date:
Subject: Re: [GENERAL] Limiting the amount of data in a variable when logging slow queries
Next
From: Guyren Howe
Date:
Subject: [GENERAL] Use function to manipulate rows — how to get separate columns, rather than single row value