X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id A9BE5D1B517
	for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
	Sun, 26 Oct 2003 04:34:56 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 52349-06
	for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
	Sun, 26 Oct 2003 01:34:26 -0300 (ADT)
Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251])
	by svr1.postgresql.org (Postfix) with ESMTP id C28C1D1B510
	for <pgsql-docs@postgresql.org>; Sun, 26 Oct 2003 01:34:24 -0300 (ADT)
Received: (from pgman@localhost)
	by candle.pha.pa.us (8.11.6/8.11.6) id h9Q4YJ909703;
	Sun, 26 Oct 2003 00:34:19 -0400 (EDT)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200310260434.h9Q4YJ909703@candle.pha.pa.us>
Subject: Re: Clarification in create_function.sgml
In-Reply-To: <1066731212.5439.3.camel@linda.lfix.co.uk>
To: Oliver Elphick <olly@lfix.co.uk>
Date: Sun, 26 Oct 2003 00:34:19 -0400 (EDT)
Cc: pgsql-docs@postgresql.org
X-Mailer: ELM [version 2.4ME+ PL108 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/36
X-Sequence-Number: 2056


I have added this to the CREATE FUNCTION manual page, in the notes
section.


---------------------------------------------------------------------------

Oliver Elphick wrote:
> It is necessary for single quotes and backslashes in a function
> definition to be escaped, but the reference page does not make this
> clear. 
> 
> diff -c -r1.52 create_function.sgml
> *** create_function.sgml        11 Sep 2003 21:42:20 -0000      1.52
> --- create_function.sgml        21 Oct 2003 10:10:08 -0000
> ***************
> *** 252,257 ****
> --- 252,261 ----
>          language.  It may be an internal function name, the path to an
>          object file, an SQL command, or text in a procedural language.
>         </para>
> +       <para>
> +        Any single quotes or backslashes in the function definition must be
> +        escaped by doubling them.
> +       </para>
>        </listitem>
>       </varlistentry>
> 
> -- 
> Oliver Elphick                                Oliver.Elphick@lfix.co.uk
> Isle of Wight, UK                             http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
>                  ========================================
>      "If ye then be risen with Christ, seek those things 
>       which are above, where Christ sitteth on the right 
>       hand of God. Set your affection on things above, not 
>       on things on the earth."              Colossians 3:1,2
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073