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 162867790909230113s4533c3a8i2b4fd8fbedbcbd44@mail.gmail.com
обсуждение исходный текст
Ответ на PL/PG SQL: select count(*) into from where - does not compute the where cond  ("Abraham, Danny" <danny_abraham@bmc.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 по дате отправления:

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