Re: SELECT statement in stored procedure - Mailing list pgsql-general

From Alan Hodgson
Subject Re: SELECT statement in stored procedure
Date
Msg-id 200607011056.27045@hal.medialogik.com
Whole thread Raw
In response to SELECT statement in stored procedure  ("Alain Roger" <raf.news@gmail.com>)
List pgsql-general
On Saturday 01 July 2006 09:08, "Alain Roger" <raf.news@gmail.com> wrote:
> it works but i get all fields from my accounts table.
>
> So how can i get only login and status ?
>

Define a composite type that includes only those fields and return SETOF
that_new_type instead of SETOF accounts.

Or select login,status from function_name() instead of select *.

--
When we vote for taxes, we are voting to steal from our neighbors


pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: Dynamic technical graphics generation inside plperl query?
Next
From: "Clodoaldo Pinto"
Date:
Subject: Postgresql does not start on reboot