Postgres Pro
Downloads
Home   >   mailing lists

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

From Jackson Ching
Subject Getting the result of a query using COUNT(*)
Date
Msg-id 200008250937570530.005FD1CF@mail.imvi.com.ph
Whole thread Raw
Responses Re: Getting the result of a query using COUNT(*)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Hi,

    I'm using JSDK 2.0 and IBM JDK 1.3 on RedHat Linux 6.2

    As i test my servlet,  I got errors saying count(*) column not found in a query like this

    SELECT COUNT(*) FROM MyTable

    in my rs.getint("COUNT(*)");   in oracle it works fine, in postgresql it doesn't. how should i handle aggregate
functionsin SQL then? 

    Thanks

Jackson

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: sorting in UNICODE table
Next
From: "ian"
Date:
Subject: where can i find a binary format win32