Selects in server side functions

From: "Neil Davis" <npdavis(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Selects in server side functions
Date: 2000-10-27 18:21:27
Message-ID: OE39nVo9ewJu8UlSFfD000010c3@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I am trying to figure out how to return more than one field using "SETOF".
I can concatenate the fields in the select statement down to one and use SETOF Text to return them, then split them back apart in my code. This is a bit kludgy though. I would rather do this correctly and efficiently. In most RDBMS you can easily deal with multiple columns in server side procedures that contain a SELECT, but I can find nothing about how to do this in PostGreSQL Documentation or anywhere else.

How can you do this with PostGreSQL? If you can, is it better to do this this way, or better to put the query inline in the code?

Please respond to the email at the bottom.

thx,
Neil P Davis
npdavis(at)hotmail(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= 2000-10-27 18:54:54 Re: [GENERAL] 7.0 vs. 7.1 (was: latest version?)
Previous Message Bruce Momjian 2000-10-27 17:05:16 Re: [GENERAL] 7.0 vs. 7.1 (was: latest version?)