Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 06FB82E0082 for ; Wed, 14 May 2008 17:50:24 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 37095-01-7 for ; Wed, 14 May 2008 17:50:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ti-out-0910.google.com (ti-out-0910.google.com [209.85.142.185]) by developer.postgresql.org (Postfix) with ESMTP id DB53A2E00C0 for ; Wed, 14 May 2008 17:49:27 -0300 (ADT) Received: by ti-out-0910.google.com with SMTP id y8so63136tia.5 for ; Wed, 14 May 2008 13:49:25 -0700 (PDT) Received: by 10.150.11.6 with SMTP id 6mr1607941ybk.11.1210798164927; Wed, 14 May 2008 13:49:24 -0700 (PDT) Received: by 10.150.134.13 with HTTP; Wed, 14 May 2008 13:49:24 -0700 (PDT) Message-ID: <937d27e10805141349o40495dcdvc6292c1f98ed294@mail.gmail.com> Date: Wed, 14 May 2008 21:49:24 +0100 From: "Dave Page" To: "Premil Agarwal" Subject: Re: [INTERFACES] Function's final statement must be a SELECT Cc: pgsql-interfaces@postgresql.org, pgsql-admin@postgresql.org In-Reply-To: <92aa956e0805141338p1a496ecdje36e03d8805e5f51@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <92aa956e0805141323y3c14fe2p4e10ba9c67637c49@mail.gmail.com> <937d27e10805141336l601c4aa2x8972c2bd7fda07e6@mail.gmail.com> <92aa956e0805141338p1a496ecdje36e03d8805e5f51@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/131 X-Sequence-Number: 29215 On Wed, May 14, 2008 at 9:38 PM, Premil Agarwal wrote: > Tried that already, still the same error It (using plpgsql instead of sql) works fine for me using your code. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com