Re: Returning multiple values (but one row) in plpgsql

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Returning multiple values (but one row) in plpgsql
Date: 2004-09-09 03:10:53
Message-ID: 87wtz4w30i.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


"Karl O. Pinc" <kop(at)meme(dot)com> writes:

> Anybody got a better idea?

If they're all the same data type you could alternatively use an array. Which
is more convenient might depend on how much you want to throw around the
composite data type in intermediate code before peeking at the elements.

--
greg

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2004-09-09 03:37:09 Re: Salt in encrypted password in pg_shadow
Previous Message Andrew Rawnsley 2004-09-09 02:46:34 Re: FYI, Sybase performance study on Linux