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 <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.
>
> ---------------------------(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
>