Re: PLPGSQL problem with SELECT INTO

From: "Jay O'Connor" <joconnor(at)cybermesa(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Jay O'Connor" <joconnor(at)cybermesa(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: PLPGSQL problem with SELECT INTO
Date: 2003-05-29 23:14:52
Message-ID: 20030529161452.E1144@altaica
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Hatcher 2003-05-29 23:47:49 How to query multiple dbases efficiently?
Previous Message Jim C. Nasby 2003-05-29 22:23:17 Re: Moving a table to a different schema