Re: Problem with ALIAS? - Mailing list pgsql-novice

From Tom Lane
Subject Re: Problem with ALIAS?
Date
Msg-id 4223.1103731723@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem with ALIAS?  ("Keith Worthington" <keithw@narrowpathinc.com>)
List pgsql-novice
"Keith Worthington" <keithw@narrowpathinc.com> writes:
> Thanks Michael.  I understand why PL/pgSQL is confused.  I was trying to set
> the value of that variable for later use not assign a column alias.  How do I
> store the value returned by the query?

SELECT ... INTO, not SELECT ... AS

            regards, tom lane

pgsql-novice by date:

Previous
From: "Keith Worthington"
Date:
Subject: Re: Problem with ALIAS?
Next
From: Tom Lane
Date:
Subject: Re: Encoding problems