Re: "CASE" is not a variable

Поиск
Список
Период
Сортировка
От Keith Worthington
Тема Re: "CASE" is not a variable
Дата
Msg-id 20060628173010.M51266@narrowpathinc.com
обсуждение исходный текст
Ответ на Re: "CASE" is not a variable  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: "CASE" is not a variable
Список pgsql-sql
> > "Keith Worthington" <keithw@narrowpathinc.com> writes:
> > The following is a section of code inside an SQL function.
> 
> On Wed, 28 Jun 2006 12:16:29 -0400, Tom Lane wrote
> SQL, or plpgsql?  It looks to me like misuse of the plpgsql INTO clause
> (there can be only one).
> 
>             regards, tom lane

plpgsql

This is part of a function inside a v8.0.2 database.

I didn't realize that the INTO clause was only limited to one instance.  I was
trying to accomplish

SELECT col_a INTO var1,      col_b INTO var2,      col_c INTO var3,      ... FROM fooWHERE fobar;

Kind Regards,
Keith


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

Предыдущее
От: "Pedro B."
Дата:
Сообщение: generate_series with left join
Следующее
От: Bricklen Anderson
Дата:
Сообщение: Re: "CASE" is not a variable