Melvin Davidson wrote:
OK, one more time.
Yes I know that right click count does that!
I know about select count(*).
I know about Right-click -> Count
The question was/is "What is the equivalent SQL function to update the
Rows(counted) value?
Right, one more time :-)
There is no SQL function. It just does a SELECT count(*) and updates the
value stored in memory (in the pgTable object to be precise).
IOW, What is the underlying code in Right-click -> Count?
Ultimately, once you get clear of all the menu handling code you get to:
void pgTable::UpdateRows()
{
pgSet *props = ExecuteSet(wxT("SELECT count(*) AS rows FROM ONLY ")
+ GetQuotedFullIdentifier());
if (props)
{
rows = props->GetLongLong(0);
delete props;
rowsCounted = true;
}
}
pgTable.rows contains the row count.
pgTable.rowsCounted is a flag that indicates that a count has been done,
rather than an estimate made (estimates come from pg_class.reltuples,
which is populated by ANALYZE).
Regards, Dave
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org