Re: Can the following be done? - Mailing list pgsql-novice

From Stephan Szabo
Subject Re: Can the following be done?
Date
Msg-id 20030826123418.O37556-100000@megazone.bigpanda.com
Whole thread Raw
In response to Can the following be done?  (Juan Francisco Diaz <j-diaz@publicar.com>)
List pgsql-novice
On Tue, 26 Aug 2003, Juan Francisco Diaz wrote:

> Create or replace function foo(param1, param2, param3) RETURNS SETOF
> RECORD(name TEXT, age INTEGER, address TEXT) AS ' ... ' LANGUAGE 'plpgsql';
>
> If this is not possible, is there any way to have always the same names and
> types for the returning columns when using SETOF RECORD?

You can make a composite type and return a set of that (you might want to
see http://techdocs.postgresql.org/guides/SetReturningFunctions )


pgsql-novice by date:

Previous
From: "Eft, Aaron"
Date:
Subject: Re: Using PostgreSQL with PHP / Scope an Lifetime of $re
Next
From: "Luis H."
Date:
Subject: Re: Using PostgreSQL with PHP / Scope an Lifetime of $result