Home > mailing lists

function returning resultset - Mailing list pgsql-sql

From	William Anthony Lim
Subject	function returning resultset
Date	March 13, 2004 01:47:55
Msg-id	CCOBCKJLAFAKKIAA@whowhere.com Whole thread Raw
List	pgsql-sql

Tree view

Hi,

I'm using PGSQL 7.4.1 and JDBC 75dev client.

I want to ask about PL/PGSQL function returning resultset.
I read in the docs, there are 'setof' and 'refcursor' method,
is there another method to returning resultset?
What advantages and disadvantages for each method?
Which is the best?

Plz explain to me. Thx.


W.A.


Need a new email address that people can remember
Check out the new EudoraMail at
http://www.eudoramail.com

pgsql-sql by date:

From: tomg@sqlclinic.net
Date: 12 March 2004, 18:55:50
Subject: pg_dump backwards compat issues

From: Yasir Malik
Date: 13 March 2004, 16:30:07
Subject: Object-relational features

function returning resultset - Mailing list pgsql-sql

Previous

Next