Getting the result of a query using COUNT(*)

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