On Wed, Jan 05, 2005 at 10:17:39 -0800,
Aaron Steele <asteele@berkeley.edu> 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.