Re: incorrect syntax for 'plpgsql' function to test boolean values - Mailing list pgsql-sql

On Aug 6, 2005, at 10:52 PM, Ferindo Middleton Jr wrote:

> ERROR:  operator does not exist: boolean == boolean
> HINT:  No operator matches the given name and argument type(s). You  
> may need to add explicit type casts.
> CONTEXT:  SQL statement "SELECT  (( $1  == true) && ( $2  == true))"
> PL/pgSQL function  
> "trigger_insert_update_registration_and_attendance" line 13 at if
>
> What is wrong with my syntax above?
>

Too much C programming :). You just want a single equal sign.

select true = true;
?column?
----------
t
(1 row)




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL