On Tue, Aug 09, 2005 at 10:49:14PM -0400, Tom Lane wrote: > Current best practice is to run the explain and parse out the "rows" > figure using a perl (or axe-of-choice) regexp, though we could be > persuaded to supply a simpler API if there's enough demand for it.
Somebody else requested a row-count-estimate function a couple of weeks ago: http://archives.postgresql.org/pgsql-admin/2005-07/msg00256.php -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match