Thread: Clarification in create_function.sgml
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
Oliver Elphick writes: > It is necessary for single quotes and backslashes in a function > definition to be escaped, but the reference page does not make this > clear. This ought to be implicit in it being a string literal. -- Peter Eisentraut peter_e@gmx.net
On Tue, 2003-10-21 at 17:42, Peter Eisentraut wrote: > Oliver Elphick writes: > > > It is necessary for single quotes and backslashes in a function > > definition to be escaped, but the reference page does not make this > > clear. > > This ought to be implicit in it being a string literal. Yes, but people sometimes need to have things spelt out. It took a fairly lengthy correspondence to convince one bug reporter that there was no bug; spelling it out for him in the reference would have helped. -- 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
Peter Eisentraut <peter_e@gmx.net> writes:
> Oliver Elphick writes:
>> It is necessary for single quotes and backslashes in a function
>> definition to be escaped, but the reference page does not make this
>> clear.
> This ought to be implicit in it being a string literal.
It is mentioned in many places, but not on that particular page.
I don't have a problem with adding something there too, but I think it
ought to go in the NOTES section rather than where Oliver has put it.
We commonly have "Don't forget that ..." kinds of items in NOTES.
regards, tom lane
Oliver, Peter, > It took a fairly lengthy correspondence to convince one bug reporter > that there was no bug; spelling it out for him in the reference would > have helped. +1; we need things spelled out. -- Josh Berkus Aglio Database Solutions San Francisco
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