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:13:50
Message-ID: 162867790909230113s4533c3a8i2b4fd8fbedbcbd44@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

Responses

Browse pgsql-general by date

  From Date Subject
Next 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
Previous Message Abraham, Danny 2009-09-23 07:39:13 PL/PG SQL: select count(*) into <var> from <tab> where <cond> - does not compute the where cond