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
I'm trying to write a function and trigger to validate that user data
entry for boolean values makes sense before being inserted or updated
into my database. I have the following trigger:
CREATE TRIGGER trigger_registration_and_attendance
BEFORE INSERT OR UPDATE
ON registration_and_attendance
F
