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!