Can a function return a record set? - Mailing list pgsql-sql

From John Taves
Subject Can a function return a record set?
Date
Msg-id 3a8f7b37_1@news.nwlink.com
Whole thread Raw
Responses Re: Can a function return a record set?  (Jie Liang <jliang@ipinc.com>)
Re: Can a function return a record set?  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
Am I correct in concluding that I can't return a record set from a function?

For example, in MS SQL I would do:

create procedure foo as
select * from yada

I expected to be able to do the following in postgresql.

create function foo (integer) returns (integer) as '
begin
select * from yada;
end; '
language 'plpgsql';

I am concluding that I can't.

jt





pgsql-sql by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: Strange parse error??
Next
From: "Kevin Quinlan"
Date:
Subject: Speed of SQL statements