Re: Make COUNT(*) Faster?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Harald Fuchs <hf0614x(at)protecting(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Make COUNT(*) Faster?
Date: 2005-07-10 16:10:25
Message-ID: 11297.1121011825@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Harald Fuchs <hf0614x(at)protecting(dot)net> writes:
> FOR row IN EXECUTE 'EXPLAIN SELECT * FROM ' || tbl LOOP
> fails with the following message:
> ERROR: cannot open non-SELECT query as cursor

[ checks CVS history... ] Use 8.0.2 or later.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rob 2005-07-10 23:20:57 Sql Query help: Remove Sub Selects
Previous Message Harald Fuchs 2005-07-10 12:19:56 Re: Make COUNT(*) Faster?