Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 5716BB5DC16 for ; Thu, 15 Sep 2011 12:31:15 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 83032-01 for ; Thu, 15 Sep 2011 15:31:09 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from mail-ey0-f174.google.com (mail-ey0-f174.google.com [209.85.215.174]) by mail.postgresql.org (Postfix) with ESMTP id AF6E3B5DC43 for ; Thu, 15 Sep 2011 12:31:08 -0300 (ADT) Received: by eya28 with SMTP id 28so418660eya.19 for ; Thu, 15 Sep 2011 08:31:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; bh=Ces0D9Ydal+UnD/4Fp4MQU8KVGLBq71EQbbneL9aqRM=; b=OaTw62Ml56yKNNVOI4iBBSWKSNK2OzrFVexx/bQsNDcAZNbPCpxNIRUMMexzEsnuHE wW7WH4PuBZjoH3GjKKZXKYwY7cXd2XkFbK98rdX9Ofi+lJGJwBtCU64zmWf1gOshJSed pA31bgDna7P5yKq7WOoCvvpvP/AOrBnsZ71M8= Received: by 10.213.4.200 with SMTP id 8mr1163883ebs.78.1316100667481; Thu, 15 Sep 2011 08:31:07 -0700 (PDT) Received: from [192.168.73.63] (5357DA75.cm-6-8d.dynamic.ziggo.nl. [83.87.218.117]) by mx.google.com with ESMTPS id d59sm9940694eea.3.2011.09.15.08.31.06 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 15 Sep 2011 08:31:06 -0700 (PDT) Message-ID: <4E721A30.1040404@gmail.com> Date: Thu, 15 Sep 2011 17:30:56 +0200 From: Yeb Havinga User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2 MIME-Version: 1.0 To: =?ISO-8859-1?Q?C=E9dric_Villemain?= CC: pgsql-hackers@postgresql.org Subject: Re: Patch for cursor calling with named parameters References: <4E71B4C4.3010004@gmail.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001 X-Spam-Level: X-Archive-Number: 201109/756 X-Sequence-Number: 194945 On 2011-09-15 16:31, Cédric Villemain wrote: > There exist also a mecanism to order the parameters of 'EXECUTE ... > USING ...' (it's using a cursor), can the current work benefit to > EXECUTE USING to use named parameters ? I looked at it a bit but it seems there is no benefit, since the dynamic sql handling vs the cursor declaration and opening touch different code paths in both the plpgsql grammar and the SPI functions that are called. regards, Yeb