hi bruno,
would it be useful to see the IF PLSQL function, or would you recommend a modification to the database.pgsql.inc file?
On Jan 5, 2005, at 10:52 AM, Bruno Wolff III wrote:
On Wed, Jan 05, 2005 at 10:17:39 -0800, Aaron Steele <[EMAIL PROTECTED]> wrote:hi,
warning: pg_query(): Query failed: ERROR: invalid input syntax for type
boolean: "2"
CONTEXT: PL/pgSQL function "if" line 2 at if in
/Library/WebServer/Documents/dmap/includes/database.pgsql.inc on line
104.
any ideas?
The actual problem is in the PLSQL function named IF that you didn't show
us.
Recent versions of postgres have tightened up casting to boolean. Perhaps in the past '2'::boolean might have worked, but in 7.4 this won't work. '1' or '0' are valid boolean representations.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
