Re: plpgsql select into with multiple target variables

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "John DeSoi" <desoi(at)pgedit(dot)com>, "PostgreSQL SQL" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: plpgsql select into with multiple target variables
Date: 2005-01-28 21:11:49
Message-ID: opslbztz2mth1vuj@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Try removing the comma after varz

> SELECT into varx, vary, varz,
> colx, coly, colz, FROM ....
>
> I've tried parens and various other things but no luck.
>
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Mischa 2005-01-29 05:58:54 Re: same question little different test MSSQL vrs Postgres
Previous Message John DeSoi 2005-01-28 21:02:13 plpgsql select into with multiple target variables