Re: [GENERAL] Does a view not define a composite type?

Поиск
Список
Период
Сортировка
От Guyren Howe
Тема Re: [GENERAL] Does a view not define a composite type?
Дата
Msg-id 3DD3B30E-0EE1-4AA7-A1EA-99F4B7830484@gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Does a view not define a composite type?  (Guyren Howe <guyren@gmail.com>)
Ответы Re: [GENERAL] Does a view not define a composite type?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения

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 по дате отправления:

Предыдущее
От: Brett Delle Grazie
Дата:
Сообщение: Re: [GENERAL] Limiting the amount of data in a variable when logging slow queries
Следующее
От: Guyren Howe
Дата:
Сообщение: [GENERAL] Use function to manipulate rows — how to get separate columns, rather than single row value