Re: Returning multiple columns with a function??

From: Neil Conway <neilc(at)samurai(dot)com>
To: RenX SalomXo <rene(at)ibiz(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Returning multiple columns with a function??
Date: 2002-12-19 19:20:25
Message-ID: 1040325625.358.151.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)samurai(dot)com> || PGP Key ID: DB3C29FC

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Barry Lind 2002-12-19 19:23:06 Re: trouble caused by change in 7.3 handling of '' in
Previous Message Neil Conway 2002-12-19 18:49:26 Re: trouble caused by change in 7.3 handling of '' in