> > This works fine, but I'm trying to avoid building a
> specific type for
> > each row returning function.
> > Is there any other solution (SQL or PLPGSQL)?
>
> Yes, return setof record, look at this site, it helped me a lot.
>
> http://techdocs.postgresql.org/guides/SetReturningFunctions
>
Hi Hervé,
You should perhaps use record instead of a particular type.
... RETURNS SETOF record AS ...
Otto
- Original Message -
From: "Hervé Inisan" <[EMAIL PROTECTED]>
To:
Sent: Thursday, May 12, 2005 8:31 PM
Subject: [GENERAL] About Types
Hi everybody,
I'm a PG newbie, and I'm trying t
[EMAIL PROTECTED] wrote:
> Hi everybody,
>
> I'm a PG newbie, and I'm trying to write a function that returns a
> set of records.
> These records come from 2 or more tables (joined).
>
> When I have only 1 table, the return type of the function can be SETOF
> mytable.
> When I have 2 tables or mo
