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: Does a view not define a composite type?
Date: 2017-04-23 17:12:54
Message-ID: 02E5459C-DCF1-4C88-A57B-E9CD182BE0DD@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brett Delle Grazie 2017-04-23 17:23:50 Re: Limiting the amount of data in a variable when logging slow queries
Previous Message Adrian Klaver 2017-04-23 15:57:14 Re: pg_basebackup issue