Re: PL/pgSQL and SETOF

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

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.

--
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 по дате отправления:

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: Re: PL/pgSQL and SETOF
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: PL/pgSQL and SETOF