X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 91A7130DC40 for ; Thu, 12 Jun 2003 14:24:13 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 76209-04 for ; Thu, 12 Jun 2003 11:24:03 -0300 (ADT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by svr1.postgresql.org (Postfix) with ESMTP id 2DC8130DC39 for ; Thu, 12 Jun 2003 11:24:03 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 7C962D61D; Thu, 12 Jun 2003 07:24:02 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 6A04E5C0B; Thu, 12 Jun 2003 07:24:02 -0700 (PDT) Date: Thu, 12 Jun 2003 07:24:02 -0700 (PDT) From: Stephan Szabo To: Robert Treat Cc: Subject: Re: control structures in plpgsql In-Reply-To: <1055427227.7392.315.camel@camel> Message-ID: <20030612071842.S25608-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200306/114 X-Sequence-Number: 13872 On 12 Jun 2003, Robert Treat wrote: > Does anyone know if there is support for "IF x OR y THEN" syntax in > plpgsql? The docs just say IF [boolean expression] then. which loosely > interpreted could allow for an OR, but I couldn't seem to get it to > work. TIA, Can you give a full example of what you're trying? I'm not seeming to have a problem in 7.3 of saying something with an OR in it apart from needing to put parentheses around things for ordering in more complicated cases.