Postgres Pro
Downloads
Home   >   mailing lists

Re: PL/pgSQL and SETOF - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: PL/pgSQL and SETOF
Date
Msg-id 20071130212132.GA3175@alvh.no-ip.org
Whole thread Raw
In response to Re: PL/pgSQL and SETOF  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Responses Re: PL/pgSQL and SETOF  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List pgsql-general
Tree view 
Pavel Stehule escribió:
> On 30/11/2007, Cultural Sublimation <cultural_sublimation@yahoo.com> wrote:

> > But still on that subject: is my version of get_items2 the simplest
> > that is possible in PL/pgSQL?  It seems awfully verbose compared to
> > the SQL version...
>
> no. Your simplest version is historic relict and is available only in
> sql language. I am not sure, maybe in C language too.

But isn't the case that on 8.3 you would be able to rewrite it more
easily using RETURN QUERY?

--
Alvaro Herrera                          Developer, http://www.PostgreSQL.org/
"Pido que me den el Nobel por razones humanitarias" (Nicanor Parra)

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: postgresql table inheritance
Next
From: Pascal Cohen
Date:
Subject: HA and Replication - how to choose among all the available solutions