Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 31A3F4760D3 for ; Wed, 2 Oct 2002 11:43:19 -0400 (EDT) Received: from hotmail.com (dav73.law15.hotmail.com [64.4.22.208]) by postgresql.org (Postfix) with ESMTP id 07E0B475E52 for ; Wed, 2 Oct 2002 11:43:16 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 2 Oct 2002 08:43:20 -0700 X-Originating-IP: [204.244.28.188] From: "david williams" To: , Subject: Re: Stored Procedures Date: Wed, 2 Oct 2002 11:47:24 -0400 MIME-Version: 1.0 X-Mailer: MSN Explorer 7.00.0021.1900 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0000_01C26A09.792EB7F0" Message-ID: X-OriginalArrivalTime: 02 Oct 2002 15:43:20.0894 (UTC) FILETIME=[6F5705E0:01C26A2A] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/13 X-Sequence-Number: 9731 ------=_NextPart_001_0000_01C26A09.792EB7F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable http://developer.postgresql.org/docs/postgres/xfunc-sql.html#AEN30400 See section=20=20 9.2.4. SQL Table Functions ----- Original Message ----- From: bcschnei@attbi.com Sent: Tuesday, October 01, 2002 4:25 PM To: pgsql-sql@postgresql.org Subject: [SQL] Stored Procedures Hi all. I'm looking for a little help here. I have a=20=20 project where I have to write some stored proceedures=20=20 and am having some problems. My main issue is, I cannot=20=20 figure out how to return a record set containing=20=20 multipule columns. I am looking for a few examples on=20=20 how I can do this. Most of what I have to do is fairly=20=20 simple SQL queries based on a pramater sent to the=20=20 function. I tried to use the SETOF option,=20=20 but only get back one column. Any help will be would be greatly appricated. Simple=20=20 examples would be of a great help. Thanks, Ben ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.orgGet more from the Web. FREE MSN Explorer dow= nload : http://explorer.msn.com ------=_NextPart_001_0000_01C26A09.792EB7F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable  
See section
 
 
----- Original Message -----
From: bcschnei@= attbi.com
Sent: Tuesday, Octob= er 01, 2002 4:25 PM
To: pgsql-= sql@postgresql.org
Subject: [S= QL] Stored Procedures
 
Hi all. I'm looking for a litt= le help here. I have a
project where I have to write some stored procee= dures
and am having some problems. My main issue is, I cannot
figur= e out how to return a record set containing
multipule columns. I am loo= king for a few examples on
how I can do this. Most of what I have to do= is fairly
simple SQL queries based on a pramater sent to the
funct= ion. I tried to use the SETOF <datatype> option,
but only get bac= k one column.

Any help will be would be greatly appricated. Simple <= BR>examples would be of a great help.

Thanks,
Ben


----= -----------------------(end of broadcast)---------------------------
TIP= 6: Have you searched our list archives?

http://archives.postgresql.= org

Get more from the Web= . FREE MSN Explorer download : http://= explorer.msn.com

------=_NextPart_001_0000_01C26A09.792EB7F0--