Re: (SETOF) RECORD AS complex_type

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: (SETOF) RECORD AS complex_type
Дата
Msg-id 25473.1167261737@sss.pgh.pa.us
обсуждение исходный текст
Ответ на (SETOF) RECORD AS complex_type  (David Fetter <david@fetter.org>)
Ответы Re: (SETOF) RECORD AS complex_type  (David Fetter <david@fetter.org>)
Список pgsql-hackers
David Fetter <david@fetter.org> writes:
> What would be involved in fixing the casting operation so that the
> following would work?

> CREATE TYPE foo AS (
>     a INT4,
>     b INT8,
>     c POINT,
>     d TEXT
> );

> CREATE FUNCTION bar(output_type TEXT)
> RETURNS SETOF RECORD
> ...

> SELECT * FROM bar('foo') AS foo;

The problem with that is that "AS foo" already has a meaning, and it's
not this one.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] [BUGS] BUG #2846: inconsistent and confusing handling of underflows,
Следующее
От: David Fetter
Дата:
Сообщение: Re: (SETOF) RECORD AS complex_type