Re: Num of returned ROWS

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