Postgres Pro
Downloads
Home   >   mailing lists

Re: number of rows returned from SELECT - Mailing list pgsql-novice

From Andrew Hammond
Subject Re: number of rows returned from SELECT
Date
Msg-id 1154132173.955394.213920@75g2000cwc.googlegroups.com
Whole thread Raw
In response to number of rows returned from SELECT  ("Corey" <corey@bitworthy.net>)
List pgsql-novice
Tree view 
> What's the most efficient way of determining the number of rows that
> _would_ be returned after/for a SELECT? Or is this impossible without...
> actually... _doing_ a SELECT?

You can't determine it without running the query. However you can ask
for a estimate.  Take a look at EXPLAIN.

pgsql-novice by date:

Previous
From: "Corey"
Date:
Subject: number of rows returned from SELECT
Next
From: Michael Fuhr
Date:
Subject: Re: number of rows returned from SELECT