executeUpdate() returns the number of rows affected. There are zero
rows affected by a SELECT COUNT(*) FROM ...
You'll need to use an executeQuery instead.
-- Mark Lewis
On Wed, 2005-06-08 at 08:38 -0300, Fernando Hartmann wrote:
> Oliver Jowett wrote:
> > Fernando Hartmann wrote:
> >
> >
> >> 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 ?
> >
> >
> > The backend doesn't return the number of rows affected for a CREATE
> > TABLE .. AS, so the driver can't give you a useful number.
> >
> > -O
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
> Ok, but and the last line ? The select count ? They don't return the
> number of rows too!
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster