X-Original-To: pgsql-patches-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id CFB5B9DCBBB for ; Thu, 2 Feb 2006 17:45:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26371-07 for ; Thu, 2 Feb 2006 17:45:24 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from trolak.mydnsbox2.com (ns1.mydnsbox2.com [207.44.142.118]) by postgresql.org (Postfix) with ESMTP id 3560B9DCBB9 for ; Thu, 2 Feb 2006 17:45:19 -0400 (AST) Received: from wired-106.internal.hcssystems.com (68.143.134.146.nw.nuvox.net [68.143.134.146]) (authenticated (0 bits)) by trolak.mydnsbox2.com (8.11.6/8.11.6) with ESMTP id k12M4nn01170; Thu, 2 Feb 2006 16:04:49 -0600 Subject: Re: [BUGS] BUG #2171: Differences compiling plpgsql in From: Andrew Dunstan To: Tom Lane Cc: Bruce Momjian , andrew5@ece.cmu.edu, PostgreSQL-patches In-Reply-To: <19109.1138916461@sss.pgh.pa.us> References: <200602020448.k124mjG25834@candle.pha.pa.us> <1138905401.5342.15.camel@swithin> <19109.1138916461@sss.pgh.pa.us> Content-Type: text/plain Date: Thu, 02 Feb 2006 16:45:06 -0500 Message-Id: <1138916707.5342.41.camel@swithin> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.073 required=5 tests=[AWL=0.073] X-Spam-Score: 0.073 X-Spam-Level: X-Archive-Number: 200602/36 X-Sequence-Number: 18701 On Thu, 2006-02-02 at 16:41 -0500, Tom Lane wrote: > Andrew Dunstan writes: > > As a matter of curiosity, why does ecpg handle dollar quoting like that? > > psql, for example, happily just passes a dollar quoted string through to > > the backend, without any need to convert it to a conventionally quoted > > string. > > Doesn't ecpg have to convert string literals into C string constants? > I believe so. But doesn't it do that by surrounding them with double quotes, and escaping embedded double quotes (and now newlines) ? The backend still needs to see what it will accept as a quote delimiter, surely. cheers andrew