From: John DeSoi <desoi@pgedit.com>
To: fmiddleton@verizon.net
Cc: 'pgsql-sql@postgresql.org' SQL <pgsql-sql@postgresql.org>
Subject: Re: incorrect syntax for 'plpgsql' function to test boolean values
Date: Sat, 6 Aug 2005 23:18:20 -0400
Message-ID: <9F3785BD-3C92-47DE-B340-0C4572F1ACCB@pgedit.com> (raw)
In-Reply-To: <42F57768.6090702@verizon.net>
References: <42F57768.6090702@verizon.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: desoi@pgedit.com, fmiddleton@verizon.net
Subject: Re: incorrect syntax for 'plpgsql' function to test boolean values
In-Reply-To: <9F3785BD-3C92-47DE-B340-0C4572F1ACCB@pgedit.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox