Re: multi results with functions

From: CoL <col(at)mportal(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: multi results with functions
Date: 2004-05-30 22:13:08
Message-ID: c9dm6p$1tqc$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hi,

kasper wrote, On 5/31/2004 00:02:
> Hi
>
> Im trying to make a stored procedure that returns * from at table, and
> returns multible rows. Can you do that, and how?
>
> basically I would like to do:
>
> create or replace function test () returns record as '
> select * from dummytable;
> ' language sql;

returns SETOF dummytable as ' ....

C.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message basic 2004-05-31 05:51:33 passing new/old record in pl/pgsql trigger functions to other functions
Previous Message kasper 2004-05-30 22:02:06 multi results with functions