Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting the result of a query using COUNT(*) - Mailing list pgsql-general

From Tom Lane
Subject Re: Getting the result of a query using COUNT(*)
Date
Msg-id 753.967175857@sss.pgh.pa.us
Whole thread Raw
In response to Getting the result of a query using COUNT(*)  ("Jackson Ching" <jching@imvi.com.ph>)
List pgsql-general
Tree view 
"Jackson Ching" <jching@imvi.com.ph> writes:
>     SELECT COUNT(*) FROM MyTable

>     in my rs.getint("COUNT(*)");

Offhand I'd guess that the returned column heading is "count" not
"COUNT(*)".  Use an AS clause if you want to be sure about the
column heading of a SELECT result...

            regards, tom lane

pgsql-general by date:

Previous
From: "ian"
Date:
Subject: where can i find a binary format win32
Next
From: "anuj"
Date:
Subject: RE: FW: Count & Distinct