RE: Re: Functions returning sets

Why not like Interbase ?

when you define a procedure in Interbase, you a the 'suspend' instruction, 
it suspend execution of the stored procedure and returns variables, then 
come back to the procedure.

select * from myfunc('ba ba');
select mycol from myfunc('dada');

escuse my poor english :)

....
Mike Mascari wrote:

> I see Tom Lane implemented the SQL92 feature of using subselects in
> FROM clauses:
> 
> CREATE TABLE foo (
> key integer not null,
> value text);
> 
> SELECT * FROM (SELECT * FROM foo) AS bar
> WHERE bar.key = 1;
> 
> Perhaps this is how functions returning sets should operate:
> 
> SELECT titles.* FROM titles, (SELECT funct_set('blah blah')) AS bar
> WHERE titles.title = bar.title;
> 
> FWIW,
> 
> Mike Mascari
> mascarm@mascari.com