Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e7P3vv589405 for ; Thu, 24 Aug 2000 23:57:57 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id XAA00756; Thu, 24 Aug 2000 23:57:38 -0400 (EDT) To: "Jackson Ching" cc: pgsql-general@postgresql.org Subject: Re: Getting the result of a query using COUNT(*) In-reply-to: <200008250937570530.005FD1CF@mail.imvi.com.ph> References: <200008250937570530.005FD1CF@mail.imvi.com.ph> Comments: In-reply-to "Jackson Ching" message dated "Fri, 25 Aug 2000 09:37:57 -0700" Date: Thu, 24 Aug 2000 23:57:37 -0400 Message-ID: <753.967175857@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200008/578 "Jackson Ching" 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