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

Reply via email to