Re: multi results with functions - Mailing list pgsql-sql

From CoL
Subject Re: multi results with functions
Date
Msg-id c9dm6p$1tqc$1@news.hub.org
Whole thread Raw
In response to multi results with functions  ("kasper" <no@spam.com>)
List 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.


pgsql-sql by date:

Previous
From: jarednevans@yahoo.com (Jared Evans)
Date:
Subject: Re: not really SQL but I need info on BLOBs
Next
From: Tom Lane
Date:
Subject: Re: insert or update violates foreign key constraint.why?