From: Benjamin Stewart <benstewart74@yahoo.com.au>
To: pgsql-sql@postgresql.org
Subject: Functions that return Record Sets
Date: Wed, 21 May 2003 20:25:28 +1000
Message-ID: <3ECB5418.6060509@yahoo.com.au> (raw)
Greetings,
Sorry if this question has been posted before, but I searched the
archives and documentation and was unable to find ther elevant
information or any other developers with first hand experience at this.
We are writting an application that is web based. We will beusing
struts, java and all the wonderful things that that technology brings.
We have decided to use Postgresql as our DB (v7.3.1). I noticed that one
of the major changes that came with the release of 7.3 was the ability
to return a record set from a function. I have not been able to find any
specific documentation on how to achieve this. If there is any I would
appreciate it if somebody could point it out.
What i really want is to hear from somebody that has first hand
experience and returning recordsets from postgresql (using pl/pgsql)
functions. The other developer here has investigated and was only able
to find a method that is a little bit tedious, and requires that actual
call to the database from the java code (using jdbc) to define the
fields that we are expecting etc.
I have worked previously with sybase and we have the ability to create a
stored procedure (different from a user defined function) that returns a
record set that is passed back as and I can use as a standard RS and
itterate throught it etc. I am also able to get meta data about field
names, type etc from the RS.
Would appreciate any help/suggestions/comments.
Regards
Ben Stewart
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: benstewart74@yahoo.com.au
Subject: Re: Functions that return Record Sets
In-Reply-To: <3ECB5418.6060509@yahoo.com.au>
* 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