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

From: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Cc: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Subject: PL/PG SQL: select count(*) into <var> from <tab> where <cond> - does not compute the where cond
Date: 2009-09-23 07:39:13
Message-ID: 2C0926ABD16BB641A8E2F11A549200421368899B12@PHXCCRPRD01.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2009-09-23 08:13:50 Re: PL/PG SQL: select count(*) into <var> from <tab> where <cond> - does not compute the where cond
Previous Message Guillaume Lelarge 2009-09-23 06:48:07 Re: Graphical representation of query plans