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 43376D1B1BC for ; Thu, 24 Jun 2004 07:33:02 -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 61758-04 for ; Thu, 24 Jun 2004 10:33:02 +0000 (GMT) Received: from millenium.mst.co.jp (unknown [210.230.185.241]) by svr1.postgresql.org (Postfix) with ESMTP id 9CD63D1B1B3 for ; Thu, 24 Jun 2004 07:32:57 -0300 (ADT) Received: from mst1x5r347kymb (lc12114 [192.168.1.114]) by millenium.mst.co.jp (8.11.6p2/3.7W) with SMTP id i5OAWbt08109; Thu, 24 Jun 2004 19:32:37 +0900 Message-ID: <002201c459d6$8a8ff4a0$7201a8c0@mst1x5r347kymb> From: "Iain" To: "sad" Cc: References: <200406231355.50079.sad@bankir.ru> <200406231012.36791.josh@agliodbs.com> <200406240856.50292.sad@bankir.ru> Subject: Re: feature request ? Date: Thu, 24 Jun 2004 19:32:25 +0900 MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/228 X-Sequence-Number: 18173 > > IF foo IS NULL > > THEN ... > > ELSIF foo > > THEN ... > > ELSE ... > > END IF; > > here the foo expression woll be executed twice if you can use an immutable or stable function then the overhead would be minimal as the system knows that it doesn't need to re-evaluate it. regards Iain