Re: 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: "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 <tab> where <cond> - does not compute the where cond
Date: 2009-09-23 08:33:15
Message-ID: 2C0926ABD16BB641A8E2F11A549200421368899C56@PHXCCRPRD01.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

... forgot the most import issue

The problem shows when the selection is from a view.

The where condition does not have names contention.

It is: select count(*) into <var> from <view_name>
where <cond>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2009-09-23 09:29:02 Re: How to have ant's <sql> task insert special chars appropriately?
Previous Message Pavel Stehule 2009-09-23 08:18:24 Re: PL/PG SQL: select count(*) into <var> from <tab> where <cond> - does not compute the where cond