RE: Re: Functions returning sets

From: mordicus <mordicus(at)free(dot)fr>
To: pgsql-hackers(at)postgresql(dot)org
Subject: RE: Re: Functions returning sets
Date: 2001-05-20 07:47:29
Message-ID: 9e7ss3$1d1c$2@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Why not like Interbase ?

when you define a procedure in Interbase, you have 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(at)mascari(dot)com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher 2001-05-20 07:50:07 DROP CONSTRAINT patch
Previous Message Jean-Michel POURE 2001-05-20 07:46:03 Re: Need Postgresql ODBC Driver