By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,542 Members | 1,434 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,542 IT Pros & Developers. It's quick & easy.

Return resultset from a function

P: n/a
Hi Every1,

I'm fairly new to Postgres and ran into a problem quite soon. Until
now I used MS Sql2000 and with it I was able to write a simple
stored procedure that returned a resultset (for example: 'select *
from table1'). But I don't know the way how to do it in Postgres,
cause I can't define a function that returns a resultset. I know
it's a lame question but I need some hints to solve this problem.

Thanks in advance!
Peter Neumann
Hungary
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Tue, Oct 12, 2004 at 04:15:28PM -0700, Neumann P?ter wrote:

I'm fairly new to Postgres and ran into a problem quite soon. Until
now I used MS Sql2000 and with it I was able to write a simple
stored procedure that returned a resultset (for example: 'select *
from table1'). But I don't know the way how to do it in Postgres,
cause I can't define a function that returns a resultset. I know
it's a lame question but I need some hints to solve this problem.


I think you're looking for a set-returning function. The following
General Bits article has examples:

http://www.varlena.com/varlena/GeneralBits/26.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.