Re: Does a view not define a composite type?

From: Guyren Howe <guyren(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Does a view not define a composite type?
Date: 2017-04-23 17:24:33
Message-ID: 3DD3B30E-0EE1-4AA7-A1EA-99F4B7830484@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> On Apr 23, 2017, at 10:12 , Guyren Howe <guyren(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeroen Jacobs 2017-04-23 17:55:40 file permission on ssl key
Previous Message Brett Delle Grazie 2017-04-23 17:23:50 Re: Limiting the amount of data in a variable when logging slow queries