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 88B3530E658 for ; Thu, 12 Jun 2003 14:13:58 +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 76195-01 for ; Thu, 12 Jun 2003 11:13:48 -0300 (ADT) Received: from localhost.localdomain (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id BC63430E586 for ; Thu, 12 Jun 2003 11:13:47 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by localhost.localdomain (8.12.8/8.12.8) with ESMTP id h5CF7H4i031246 for ; Thu, 12 Jun 2003 11:07:17 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h5CEDmZ11734 for ; Thu, 12 Jun 2003 10:13:48 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id MTKBN294; Thu, 12 Jun 2003 10:13:45 -0400 Subject: control structures in plpgsql From: Robert Treat To: pgsql-sql@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 12 Jun 2003 10:13:47 -0400 Message-Id: <1055427227.7392.315.camel@camel> Mime-Version: 1.0 X-Archive-Number: 200306/112 X-Sequence-Number: 13870 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, Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL