Re: PL/pgSQL and SETOF

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: PL/pgSQL and SETOF
Дата
Msg-id 162867790711301331m78e45ceg4b5fa02cef251fdd@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PL/pgSQL and SETOF  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: PL/pgSQL and SETOF
Список pgsql-general
On 30/11/2007, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> 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?
>

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)
>

В списке pgsql-general по дате отправления:

Предыдущее
От: Pascal Cohen
Дата:
Сообщение: HA and Replication - how to choose among all the available solutions
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: PL/pgSQL and SETOF