Re: Variable column name - Mailing list pgsql-general

From Bill Moran
Subject Re: Variable column name
Date
Msg-id 20110902135308.97d80d35.wmoran@potentialtech.com
Whole thread Raw
In response to Re: Variable column name  ("Bob Pawley" <rjpawley@shaw.ca>)
Responses Re: Variable column name
List pgsql-general
In response to "Bob Pawley" <rjpawley@shaw.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/

pgsql-general by date:

Previous
From: "Bob Pawley"
Date:
Subject: Re: Variable column name
Next
From: Martín Marqués
Date:
Subject: pg_lock_status not documented