Re: PL/PG SQL: select count(*) into <var> from <ANY VIEW> where <cond> - does not compute the where cond - returns always total count

From:	"Abraham, Danny" <danny_abraham(at)bmc(dot)com>
To:	"Abraham, Danny" <danny_abraham(at)bmc(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject:	Re: PL/PG SQL: select count(*) into <var> from <ANY VIEW> where <cond> - does not compute the where cond - returns always total count
Date:	2009-09-23 10:04:09
Message-ID:	2C0926ABD16BB641A8E2F11A549200421368899E14@PHXCCRPRD01.adprod.bmc.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2009-09-23 08:33:15 from "Abraham, Danny" <danny_abraham(at)bmc(dot)com>  2009-09-23 10:04:09 from "Abraham, Danny" <danny_abraham(at)bmc(dot)com>   2009-09-23 10:25:15 from "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>   2009-09-23 11:26:18 from Martin Gainty <mgainty(at)hotmail(dot)com>
Lists:	pgsql-general

In response to

• Re: PL/PG SQL: select count(*) into <var> from <tab> where <cond> - does not compute the where cond at 2009-09-23 08:33:15 from Abraham, Danny

Responses

• Re: Re: PL/PG SQL: select count(*) into <var> from <ANY VIEW> where <cond> - does not compute the where cond - returns always total count at 2009-09-23 10:25:15 from A. Kretschmer
• Re: Re: PL/PG SQL: select count(*) into <var> from <ANY VIEW> where <cond> - does not compute the where cond - returns always total count at 2009-09-23 11:26:18 from Martin Gainty

Browse pgsql-general by date

	From	Date	Subject
Next Message	Richard Huxton	2009-09-23 10:22:33	Re: How to have ant's <sql> task insert special chars appropriately?
Previous Message	J. Roeleveld	2009-09-23 09:35:03	Re: How to have ant's <sql> task insert special chars appropriately?