Re: Re: [SQL] PL/PGSQL function with parameters

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re: [SQL] PL/PGSQL function with parameters
Дата
Msg-id 26601.981506590@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [SQL] PL/PGSQL function with parameters  (Florent Guillaume <efgeor@noos.fr>)
Список pgsql-hackers
Florent Guillaume <efgeor@noos.fr> writes:
> On this same subject, the plpgsql doc says to use
>     SELECT expression INTO var FROM ...
> but Bruce's book, in several examples ("PL/PGSQL Functions" for instance,
> node203.html) uses
>     SELECT INTO var expression FROM ...
> Both should work, but there may be there's something to straighten up here.

IIRC, the plpgsql code is actually *very* lax about where you put the
INTO; it'll suck it out from almost anyplace in the query string ...
        regards, tom lane


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

Предыдущее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: OID from insert has extra letter
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Duplicate OIDs in pg_attribute