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 A5C56D1B562 for ; Tue, 21 Oct 2003 16:46:47 +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 04204-05 for ; Tue, 21 Oct 2003 13:46:17 -0300 (ADT) Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by svr1.postgresql.org (Postfix) with ESMTP id 862F4D1B559 for ; Tue, 21 Oct 2003 13:46:15 -0300 (ADT) Received: from lfix.demon.co.uk ([80.177.205.209] helo=cerberus.lfix.co.uk) by anchor-post-31.mail.demon.net with esmtp (Exim 3.35 #1) id 1ABzeB-000LqO-0V; Tue, 21 Oct 2003 17:46:15 +0100 Received: from linda.lfix.co.uk ([192.168.1.1]) by cerberus.lfix.co.uk with esmtp (Exim 4.24) id 1ABze3-0007fR-Fp; Tue, 21 Oct 2003 17:46:07 +0100 Subject: Re: Clarification in create_function.sgml From: Oliver Elphick To: Peter Eisentraut Cc: pgsql-docs@postgresql.org In-Reply-To: References: Content-Type: text/plain Organization: LFIX Limited Message-Id: <1066754767.17851.1.camel@linda.lfix.co.uk> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Tue, 21 Oct 2003 17:46:07 +0100 Content-Transfer-Encoding: 7bit X-LFIX-MailScanner: Found to be clean X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/26 X-Sequence-Number: 2046 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