"Pit M." <[EMAIL PROTECTED]> writes:
> Following query fails in pgAdmin which is OK because the field PLZZ
> contains characters:
> select * from "PERSONEN" where (CAST("PERSONEN"."PLZZ" AS INTEGER) >=
> 70000 );
> but if using the same query with a cursor ist works:
> START TRANSACTION;
> DECLARE c21112234 SCROLL CURSOR FOR select * from "PERSONEN" where
> (CAST("PERSONEN"."PLZZ" AS INTEGER) >= 70000;
> COMMIT;
> In my opinion this query should also fail with cursors.
It would have failed if you had run the cursor far enough to fetch one
of the bad rows.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
