| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | Cultural Sublimation <cultural_sublimation(at)yahoo(dot)com>, Sam Mason <sam(at)samason(dot)me(dot)uk>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PL/pgSQL and SETOF |
| Date: | 2007-11-30 21:21:32 |
| Message-ID: | 20071130212132.GA3175@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Pavel Stehule escribió:
> On 30/11/2007, Cultural Sublimation <cultural_sublimation(at)yahoo(dot)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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pascal Cohen | 2007-11-30 21:30:47 | HA and Replication - how to choose among all the available solutions |
| Previous Message | Jeff Davis | 2007-11-30 20:52:31 | Re: postgresql table inheritance |