Yeah, I guess so..... I just didn't want the compiler to think I was trying to assign the value..... And I also figured out that instead of the &&, I needed to just say AND.... Thanks.

Ferindo

John DeSoi wrote:


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



--
Ferindo Middleton
Chief Architect
Sleekcollar.com


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

Reply via email to