Re: Help making a plpgsql function? - Mailing list pgsql-general

From Bjørn T Johansen
Subject Re: Help making a plpgsql function?
Date
Msg-id 20060705215115.3007ab75@pennywise
Whole thread Raw
In response to Re: Help making a plpgsql function?  (Dany De Bontridder <dany@alchimerys.be>)
Responses Re: Help making a plpgsql function?
Re: Help making a plpgsql function?
List pgsql-general
Yes, but I need to return n fields from one table and n fiels from another, and n fields from yet another
table, etc... and return this as some kind of record... How do I to this?


BTJ

On Wed, 5 Jul 2006 19:13:39 +0200
Dany De Bontridder <dany@alchimerys.be> wrote:

> On Wednesday 05 July 2006 16:46, Bjørn T Johansen wrote:
> > I need to make a funtion that take one parameter and then returns a
> > "record" with x number of fields, collected from x no. of tables, i.e. I
> > need to run several sql statemtents to collect all the needed values from x
> > no. of fields and insert it into a "record" and return the "record" at the
> > end...
> From http://www.postgresql.org/docs/7.4/interactive/plpgsql-declarations.html
>
> Example for function having return type set of record
>
> create function testfunc(int) returns record as '
> declare
>         output record;
> begin
>         for output in select * from table1 where col1<$1 loop
>         return next output;
>         end loop;
> return;
> end;
> ' language plpgsql
>
> executing through sql as:
>
> select * from testfunc(6) as (col1 int, col2 float, col3 char(20));
>
>
> Regards,
>
> D.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly

pgsql-general by date:

Previous
From: Kenneth Downs
Date:
Subject: Re: User privileges in web database applications
Next
From: "Angshu Kar"
Date:
Subject: basic log question