Re: PL/pgSQL and SETOF

Поиск
Список
Период
Сортировка
Искать
От
Pavel Stehule
Тема
Re: PL/pgSQL and SETOF
Дата
Msg-id
162867790711301341v58b52df6p2203296aafd8ce7b@mail.gmail.com
Ответ на
Re: PL/pgSQL and SETOF (Alvaro Herrera)
Список
Дерево обсуждения
PL/pgSQL and SETOF Cultural Sublimation <cultural_sublimation@yahoo.com>
Re: PL/pgSQL and SETOF "Pavel Stehule" <pavel.stehule@gmail.com>
Re: PL/pgSQL and SETOF Sam Mason <sam@samason.me.uk>
Re: PL/pgSQL and SETOF Cultural Sublimation <cultural_sublimation@yahoo.com>
Re: PL/pgSQL and SETOF "Pavel Stehule" <pavel.stehule@gmail.com>
Re: PL/pgSQL and SETOF Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: PL/pgSQL and SETOF "Pavel Stehule" <pavel.stehule@gmail.com>
Re: PL/pgSQL and SETOF Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: PL/pgSQL and SETOF "Pavel Stehule" <pavel.stehule@gmail.com>
Re: PL/pgSQL and SETOF "Merlin Moncure" <mmoncure@gmail.com>
Re: PL/pgSQL and SETOF "Pavel Stehule" <pavel.stehule@gmail.com>
Re: PL/pgSQL and SETOF "Merlin Moncure" <mmoncure@gmail.com>
On 30/11/2007, Alvaro Herrera  wrote:
> Pavel Stehule escribió:
> > On 30/11/2007, Alvaro Herrera  wrote:
> > > Pavel Stehule escribió:
> > > > On 30/11/2007, Cultural Sublimation  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.
>
> Hmm, you are misunderstanding Cultural or I am.  I think his verbosity
> comment is not about the way the function is called, but rather about
> the function body itself.
>

It's my English. I am sorry. You have true.

Thank you for correction

Pavel

> --
> Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
> "Before you were born your parents weren't as boring as they are now. They
> got that way paying your bills, cleaning up your room and listening to you
> tell them how idealistic you are."  -- Charles J. Sykes' advice to teenagers
>
В списке pgsql-general по дате отправления
От: Alvaro Herrera
Дата:
Сообщение: Re: PL/pgSQL and SETOF
От: Martijn van Oosterhout
Дата:
FAQ