Re: PL/pgSQL and SETOF

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: PL/pgSQL and SETOF
Дата
Msg-id 20071130212132.GA3175@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: PL/pgSQL and SETOF  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Ответы Re: PL/pgSQL and SETOF
Список pgsql-general
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?

--
Alvaro Herrera                          Developer, http://www.PostgreSQL.org/
"Pido que me den el Nobel por razones humanitarias" (Nicanor Parra)

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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: postgresql table inheritance
Следующее
От: Pascal Cohen
Дата:
Сообщение: HA and Replication - how to choose among all the available solutions