Received: from cypress.compass.com.ph (cypress.compass.com.ph [202.167.28.6]) by hub.org (8.10.1/8.10.1) with ESMTP id e7P1Tr550202 for ; Thu, 24 Aug 2000 21:29:53 -0400 (EDT) Received: from matrix (gob108.compass.com.ph [202.167.32.108]) by cypress.compass.com.ph (8.9.3/8.9.3) with ESMTP id JAA27765 for ; Fri, 25 Aug 2000 09:29:05 +0800 (HKT) Message-ID: <200008250937570530.005FD1CF@mail.imvi.com.ph> X-Mailer: Calypso Version 3.10.03.02 (3) Date: Fri, 25 Aug 2000 09:37:57 -0700 From: "Jackson Ching" To: pgsql-general@postgresql.org Subject: Getting the result of a query using COUNT(*) Mime-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id e7P1Tt550205 X-Archive-Number: 200008/575 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 functions in SQL then? Thanks Jackson