X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id D6424D1C50F for ; Wed, 23 Jul 2003 18:24:52 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 49411-09 for ; Wed, 23 Jul 2003 15:24:07 -0300 (ADT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by svr1.postgresql.org (Postfix) with ESMTP id AF482D1C511 for ; Wed, 23 Jul 2003 15:24:47 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3248623; Wed, 23 Jul 2003 11:25:05 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: elein , Robert Treat Subject: Re: obtuse plpgsql function needs Date: Wed, 23 Jul 2003 11:24:31 -0700 User-Agent: KMail/1.4.3 Cc: elein@varlena.com, pgsql-sql@postgresql.org References: <1058913112.22259.271.camel@camel> <1058965609.22259.292.camel@camel> <20030723111201.D20411@cookie> In-Reply-To: <20030723111201.D20411@cookie> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200307231124.31871.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/342 X-Sequence-Number: 14456 Elein, Robert, I think Robert can do this in 7.3.3, and in PL/pgSQL. But I'm not going any further on it until Robert clarifies his examples, because I'm not sure what he's talking about. In your example, Robert, you use "f1" to indicate both the column f1 and the value of the column f1. This makes it impossible for me to understand which of the two you want. Try again? -- Josh Berkus Aglio Database Solutions San Francisco