Re: "CASE" is not a variable

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: "PostgreSQL SQL" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: "CASE" is not a variable
Date: 2006-06-28 17:34:58
Message-ID: 20060628173010.M51266@narrowpathinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> > "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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bricklen Anderson 2006-06-28 17:48:31 Re: "CASE" is not a variable
Previous Message Tom Lane 2006-06-28 16:16:29 Re: "CASE" is not a variable