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>