Postgres Pro
Downloads
Home   >   mailing lists

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

From Guyren Howe
Subject [GENERAL] Does a view not define a composite type?
Date
Msg-id 02E5459C-DCF1-4C88-A57B-E9CD182BE0DD@gmail.com
Whole thread Raw
Responses Re: [GENERAL] Does a view not define a composite type?  (Guyren Howe <guyren@gmail.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] pg_basebackup issue
Next
From: Brett Delle Grazie
Date:
Subject: Re: [GENERAL] Limiting the amount of data in a variable when logging slow queries