Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id CBCED4762EE; Tue, 18 Jun 2002 11:33:27 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id A61E14762E9; Tue, 18 Jun 2002 10:48:58 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g5IEmrb26290; Tue, 18 Jun 2002 10:48:53 -0400 (EDT) To: josh@agliodbs.com Cc: pgsql-sql@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: Request for builtin function: Double_quote In-reply-to: <200206171334.01532.josh@agliodbs.com> References: <200206171334.01532.josh@agliodbs.com> Comments: In-reply-to Josh Berkus message dated "Mon, 17 Jun 2002 13:34:01 -0700" Date: Tue, 18 Jun 2002 10:48:53 -0400 Message-ID: <26287.1024411733@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200206/228 X-Sequence-Number: 8193 Josh Berkus writes: > Given the amount of qoute nesting we do in Postgres, I thought that we need a > function that handles automatic doubling of quotes within strings. I've > written one in PL/pgSQL (below). I'd really love to see this turned into a > builtin C function. What does this do that isn't already done by quote_literal? regards, tom lane