From: | Rory Campbell-Lange <rory(at)campbell-lange(dot)net> |
---|---|
To: | Postgresql General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Options for select from function returning record? |
Date: | 2003-06-11 13:56:16 |
Message-ID: | 20030611135616.GB24986@campbell-lange.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)campbell-lange(dot)net>
<www.campbell-lange.net>
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2003-06-11 14:02:06 | Re: Options for select from function returning record? |
Previous Message | Rory Campbell-Lange | 2003-06-11 13:52:55 | Return Record with CASE problem |