From: ritchie turner <ritchie@ipowerhouse.com>
To: Benjamin Stewart <benstewart74@yahoo.com.au>
To: pgsql-sql@postgresql.org
Subject: Re: Functions that return Record Sets
Date: Tue, 20 May 2003 21:39:43 -0700
Message-ID: <200305202139.43836.ritchie@ipowerhouse.com> (raw)
In-Reply-To: <3ECB5418.6060509@yahoo.com.au>
References: <3ECB5418.6060509@yahoo.com.au>
Your in luck
http://www.varlena.com/GeneralBits/
Has a good tutorial on that.
Cheers
Ritchie
On Wednesday 21 May 2003 03:25, Benjamin Stewart wrote:
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
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: ritchie@ipowerhouse.com, benstewart74@yahoo.com.au
Subject: Re: Functions that return Record Sets
In-Reply-To: <200305202139.43836.ritchie@ipowerhouse.com>
* 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