Thread: Return resultset from a function

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

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/