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 [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
