Keith Worthington wrote:
"Keith Worthington" <[EMAIL PROTECTED]> 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
try it like
select col_a,col_b,col_c INTO va1,var2,var3 ....
not sure if 8.0.2 allows you to do that, however.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
