Re: PL/PG SQL: select count(*) into <var> from <tab> where <cond> - does not compute the where cond

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PL/PG SQL: select count(*) into <var> from <tab> where <cond> - does not compute the where cond
Date: 2009-09-23 08:18:24
Message-ID: 162867790909230118ha0dba81iad7972cfcdbe68e9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

try to check if there are some column names are equal to variable names.

This is symptom of identifier collision.

regards

Pavel Stehule

>
> 2009/9/23 Abraham, Danny <danny_abraham(at)bmc(dot)com>:
>> Instead it returns the full count of the table.
>>
>> Any idea?
>>
>> Thanks
>>
>> Danny Abraham
>> BMC Software
>> CTM&D Business Unit
>> 972-52-4286-513
>> danny_abraham(at)bmc(dot)com
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Abraham, Danny 2009-09-23 08:33:15 Re: PL/PG SQL: select count(*) into <var> from <tab> where <cond> - does not compute the where cond
Previous Message A. Kretschmer 2009-09-23 08:15:04 Re: PL/PG SQL: select count(*) into <var> from <tab> where <cond> - does not compute the where cond