Num of returned ROWS

From: Fernando Hartmann <fh(at)sadig(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Num of returned ROWS
Date: 2005-06-07 19:41:13
Message-ID: d84t1f$pj1$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


I'm using Postgres 8.0.3 and JDBC build 311 (tried 400 too) and using
executeUpdate to send the following command to DB:

set datestyle to ISO,DMY;
create table table1 as select F1, sum(F10) from table where F1 between
'1/1/2001' and '31/12/2004' group by F1;
select count(*) from table1

But the executeUpdate always return 0, even when the cont(*) return a
number other than 0.

Any ideas ?

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Sathyajith G 2005-06-07 20:05:28 Re: exception while upgrading driver
Previous Message Kris Jurka 2005-06-07 19:15:59 Re: exception while upgrading driver