Re: Returning multiple columns with a function?? - Mailing list pgsql-general

From Neil Conway
Subject Re: Returning multiple columns with a function??
Date
Msg-id 1040325625.358.151.camel@tokyo
Whole thread Raw
In response to Re: Returning multiple columns with a function??  (Renê Salomão <rene@ibiz.com.br>)
List pgsql-general
On Thu, 2002-12-19 at 14:31, RenX SalomXo wrote:
> Is it possible for Pg 7.3 to have a SETOF <return_type> in a function
> using any other language besides sql? Pgplsql, for example?

Yes -- set-returning functions are supported in SQL, PL/PgSQL and C as
of 7.3.

See the documentation for RETURN NEXT here:

http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/plpgsql-control-structures.html

Cheers,

Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC




pgsql-general by date:

Previous
From: Barry Lind
Date:
Subject: Re: trouble caused by change in 7.3 handling of '' in
Next
From: Greg Stark
Date:
Subject: Re: Batch Insert Performance