Options for select from function returning record?

Поиск
Список
Период
Сортировка
От Rory Campbell-Lange
Тема Options for select from function returning record?
Дата
Msg-id 20030611135616.GB24986@campbell-lange.net
обсуждение исходный текст
Ответы Re: Options for select from function returning record?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
I'm interested to know what options there are in selecting values from a
function returning a RECORD.

For instance, in the query below:

temporary=> SELECT
                *
            FROM
                fn_v1_board_view_board (1, 1)
            AS (n_id integer, t_description varchar, t_name varchar,
                typer integer, n_id_photo integer);

it would be convenient to be able to omit some columns on occasion. Is
this possible, as if the record returned was like a table.

Also is it possible to ever truncate this sort of select as

temporary=> SELECT
                *
            FROM
                fn_v1_board_view_board (1, 1);

ommitting the "AS"?

Thanks,
Rory

--
Rory Campbell-Lange
<rory@campbell-lange.net>
<www.campbell-lange.net>

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

Предыдущее
От: Rory Campbell-Lange
Дата:
Сообщение: Return Record with CASE problem
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Options for select from function returning record?