Re: Variable column name - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Variable column name
Date
Msg-id 4E611480.9040901@iol.ie
Whole thread Raw
In response to Re: Variable column name  ("Bob Pawley" <rjpawley@shaw.ca>)
Responses Re: Variable column name  ("Bob Pawley" <rjpawley@shaw.ca>)
List pgsql-general
On 02/09/2011 18:33, Bob Pawley wrote:
>
>
> -----Original Message-----
>> From: Bill Moran
> Sent: Thursday, September 01, 2011 8:19 AM
> To: Bob Pawley
> Cc: Postgresql
> Subject: Re: [GENERAL] Variable column name
>
> http://www.postgresql.org/docs/9.0/static/plpgsql-statements.html
> Section 39.5.4
>
> If you're not familiar with plpgsql at all, you might want to start with
> this:
> http://www.postgresql.org/docs/9.0/static/plpgsql-structure.html
>
>
> Thanks for the suggestion.
>
> Following is my interpretation of what I have read.
>
> I am getting an error  -- "column "1" does not exist"
>
> Could someone point to what I am doing wrong?
>
> Bob
>
>  Select 2 into point_array ;
>    Select "1" into column ;

Hi Bob,

I think it is the double-quotes around the 1; just leave them out to get
a literal integer 1:

  select 1 into column;

If I understand correctly, the double-quotes make Postgres look for a
column named "1".

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

pgsql-general by date:

Previous
From: "Bob Pawley"
Date:
Subject: Re: Variable column name
Next
From: "Bob Pawley"
Date:
Subject: Re: Variable column name