Following query fails in pgAdmin which is OK because the field PLZZ
select * from "PERSONEN" where (CAST("PERSONEN"."PLZZ" AS INTEGER) >=
but if using the same query with a cursor ist works:
DECLARE c21112234 SCROLL CURSOR FOR select * from "PERSONEN" where
(CAST("PERSONEN"."PLZZ" AS INTEGER) >= 70000;
In my opinion this query should also fail with cursors.
I use libpq with PG 8.2.1.
The field PLZZ is of type varchar.
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2007-05-23 13:49:31|
|Subject: Re: ERROR: invalid input syntax for integer: "" |
|Previous:||From: Ferdinand||Date: 2007-05-23 06:03:05|
|Subject: BUG #3299: pgadmin3 explain partial object name displayed|