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