| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org> |
| 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:31:17 |
| Message-ID: | 162867790711301331m78e45ceg4b5fa02cef251fdd@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 30/11/2007, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
> 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?
>
yes. sure. But it is different question than call SRF function in
normal context.
Pavel
> --
> Alvaro Herrera Developer, http://www.PostgreSQL.org/
> "Pido que me den el Nobel por razones humanitarias" (Nicanor Parra)
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-11-30 21:35:33 | Re: PL/pgSQL and SETOF |
| Previous Message | Pascal Cohen | 2007-11-30 21:30:47 | HA and Replication - how to choose among all the available solutions |