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
