Re: Variable column name

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: "Postgresql" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Variable column name
Date: 2011-09-02 17:53:08
Message-ID: 20110902135308.97d80d35.wmoran@potentialtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In response to "Bob Pawley" <rjpawley(at)shaw(dot)ca>:
>
> I am getting an error -- "column "1" does not exist"

<snip>

> Select "1" into column ;

Where are you selecting "1" from? This query has no FROM clause, so of
course the column doesn't exist.

The previous query, "SELECT 2 INTO point_array" is going to put the
integer value 2 into the variable point_array, which I'm guessing is
not what you want either.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martín Marqués 2011-09-02 19:12:30 pg_lock_status not documented
Previous Message Bob Pawley 2011-09-02 17:45:42 Re: Variable column name