Re: "CASE" is not a variable - Mailing list pgsql-sql

From Keith Worthington
Subject Re: "CASE" is not a variable
Date
Msg-id 20060628173010.M51266@narrowpathinc.com
Whole thread Raw
In response to Re: "CASE" is not a variable  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: "CASE" is not a variable
List 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 by date:

Previous
From: "Pedro B."
Date:
Subject: generate_series with left join
Next
From: Bricklen Anderson
Date:
Subject: Re: "CASE" is not a variable