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

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: PL/PG SQL: select count(*) into from where - does not compute the where cond
Дата
Msg-id 162867790909230118ha0dba81iad7972cfcdbe68e9@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PL/PG SQL: select count(*) into from where - does not compute the where cond  (Pavel Stehule <pavel.stehule@gmail.com>)
Список 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@bmc.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@bmc.com
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>

В списке pgsql-general по дате отправления:

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: PL/PG SQL: select count(*) into from where - does not compute the where cond
Следующее
От: "Abraham, Danny"
Дата:
Сообщение: Re: PL/PG SQL: select count(*) into from where - does not compute the where cond