Options for select from function returning record?

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>

Responses

Browse pgsql-general by date

  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