Re: PLPGSQL problem with SELECT INTO - Mailing list pgsql-general

From Jay O'Connor
Subject Re: PLPGSQL problem with SELECT INTO
Date
Msg-id 20030529161452.E1144@altaica
Whole thread Raw
In response to Re: PLPGSQL problem with SELECT INTO  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 2003.05.29 14:41 Tom Lane wrote:

> I kinda suspect you have an unexpected variable substitution.  Is the
> above *exactly* how the offending function reads, or have you
> editorialized on the names used?

It was editorialized and in the editorializing I obscured the real issue.
I had a local variable name and a column name in my query as the same name,
differenitated only by case.  Unfortunately, plpgsql did not see them as
different :)

Take care,
Jay

pgsql-general by date:

Previous
From: nolan@celery.tssi.com
Date:
Subject: Re: How to deny user changing his own password?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Moving a table to a different schema