From: Leif B. Kristensen <leif@solumslekt.org>
To: pgsql-sql@postgresql.org
Subject: Re: Multiple return values and assignment
Date: Mon, 27 Apr 2009 21:37:47 +0200
Message-ID: <200904272137.47709.leif@solumslekt.org> (raw)
In-Reply-To: <gt3rgq$f6m$1@reversiblemaps.ath.cx>
References: <200904251306.44880.leif@solumslekt.org>
<gt3rgq$f6m$1@reversiblemaps.ath.cx>
On Monday 27. April 2009, Jasen Betts wrote:
>SELECT * FROM get_sort(par_id, srt, txt) INTO srt,txt;
Thank you very much! That saved me from one composite variable
declaration and two superfluous lines of code. I've settled for
SELECT number, string FROM get_sort(par_id, srt, txt) INTO srt, txt;
as that seems a little tidier.
I probably should have thought of it myself, but I wrongly assumed that
it was impossible to do multiple assignments like this in plpgsql.
--
Leif Biberg Kristensen | Registered Linux User #338009
Me And My Database: http://solumslekt.org/blog/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: leif@solumslekt.org
Subject: Re: Multiple return values and assignment
In-Reply-To: <200904272137.47709.leif@solumslekt.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox