Skip site navigation (1) Skip section navigation (2)

function returning resultset

From: "William Anthony Lim" <wei(dot)liang(at)eudoramail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: function returning resultset
Date: 2004-03-13 02:47:37
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql

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.


Need a new email address that people can remember
Check out the new EudoraMail at

pgsql-sql by date

Next:From: Yasir MalikDate: 2004-03-13 17:30:02
Subject: Object-relational features
Previous:From: tomgDate: 2004-03-12 19:58:12
Subject: pg_dump backwards compat issues

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group