Re: About Types

From: Hervé Inisan <typo3(at)self-access(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: About Types
Date: 2005-05-12 20:43:30
Message-ID: 20050512204048.D27B4173536@postfix3-1.free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > 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
>

Thank you Miguel and Otto.
RECORD did the trick :-)

-- Hervé Inisan.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hervé Inisan 2005-05-12 21:06:31 Re: MS-Access and Stored procedures
Previous Message Madeleine Theile 2005-05-12 20:38:31 Re: alter table owner doesn't update acl information