X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3BBAD52BAA for ; Sun, 7 Aug 2005 00:18:42 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 27572-10 for ; Sun, 7 Aug 2005 03:18:32 +0000 (GMT) Received: from a2s4.a2hosting.com (a2s4.a2hosting.com [64.9.205.220]) by svr1.postgresql.org (Postfix) with ESMTP id C4C5152BA4 for ; Sun, 7 Aug 2005 00:18:30 -0300 (ADT) Received: from user-1120s32.dsl.mindspring.com ([66.32.112.98] helo=[192.168.1.10]) by a2s4.a2hosting.com with esmtpsa (TLSv1:RC4-SHA:128) (Exim 4.51) id 1E1bgD-0006iF-18; Sat, 06 Aug 2005 23:18:29 -0400 In-Reply-To: <42F57768.6090702@verizon.net> References: <42F57768.6090702@verizon.net> Mime-Version: 1.0 (Apple Message framework v733) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <9F3785BD-3C92-47DE-B340-0C4572F1ACCB@pgedit.com> Cc: "'pgsql-sql@postgresql.org' SQL" Content-Transfer-Encoding: 7bit From: John DeSoi Subject: Re: incorrect syntax for 'plpgsql' function to test boolean values Date: Sat, 6 Aug 2005 23:18:20 -0400 To: fmiddleton@verizon.net X-Mailer: Apple Mail (2.733) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - a2s4.a2hosting.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - pgedit.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.009 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200508/37 X-Sequence-Number: 22265 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