From: | Ralph Smith <rsmith(at)10kinfo(dot)com> |
---|---|
To: | |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: A Query that works standalone but not in a f(x) |
Date: | 2011-01-20 21:17:10 |
Message-ID: | 4D38A656.8050102@10kinfo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Once again, youreka, or EUREKA Tom!
There was no indication that the problem was inside the loop, just the
query wouldn't work.
In fact it ran perfectly fine yesterday!...? (Though I am going to go
back and check it now.)
Thanks. I know better but... You can bet I won't make that one again.
Ralph
========================================
Tom Lane wrote:
> Ralph Smith <rsmith(at)10kinfo(dot)com> writes:
>
>> Within the function I have:
>>
>
>
>> for darec in select * from purchbt where addr not like ''%STE%STE%'' and
>> addr not like ''%STE%STE%STE%'' and (addr similar to
>> ''%STE[A-Z]*[0-9]+'' or addr similar to ''%STE[A-Z]*[0-9]+[A-Z]'' or
>> addr similar to ''%STE[A-Z]*[0-9]+[A-Z][A-Z]'') loop
>>
>
>
>> and it finds no records.
>> Outside the function, replace '' with ', I DO get the results I expect.
>>
>
> Maybe "addr" is the name of a local variable inside the function?
> Pre-9.0, that sort of ambiguity can bite you pretty easily.
>
> regards, tom lane
>
--
Ralph
_________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Bosco Rama | 2011-01-20 21:24:35 | Large object corruption during 'piped' pg_restore |
Previous Message | Robert Paresi | 2011-01-20 21:10:27 | Re: Moving from SQL Anywhere to PostGres - First Time |