Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: PL/pgSQL and SETOF
- 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: Fri, 30 Nov 2007 22:31:17 +0100
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) >
- Follow-Ups:
- Re: PL/pgSQL and SETOF
- From: Alvaro Herrera
- Re: PL/pgSQL and SETOF
- References:
- Re: PL/pgSQL and SETOF
- From: Sam Mason
- Re: PL/pgSQL and SETOF
- From: Cultural Sublimation
- Re: PL/pgSQL and SETOF
- From: Pavel Stehule
- Re: PL/pgSQL and SETOF
- From: Alvaro Herrera
- Re: PL/pgSQL and SETOF
- Prev by Date: HA and Replication - how to choose among all the available solutions
- Next by Date: Re: PL/pgSQL and SETOF
- Previous by thread: Re: PL/pgSQL and SETOF
- Next by thread: Re: PL/pgSQL and SETOF
- Indexes: