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: 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@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
