Re: "CASE" is not a variable

["Keith Worthington" <keithw(at)narrowpathinc(dot)com>]

> > "Keith Worthington" <keithw(at)narrowpathinc(dot)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 foo
 WHERE fobar;

Kind Regards,
Keith