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 CBD57D1B53C for ; Tue, 21 Oct 2003 10:14:19 +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 25970-09 for ; Tue, 21 Oct 2003 07:13:51 -0300 (ADT) Received: from anchor-post-33.mail.demon.net (anchor-post-33.mail.demon.net [194.217.242.91]) by svr1.postgresql.org (Postfix) with ESMTP id EE03FD1B54E for ; Tue, 21 Oct 2003 07:13:47 -0300 (ADT) Received: from lfix.demon.co.uk ([80.177.205.209] helo=cerberus.lfix.co.uk) by anchor-post-33.mail.demon.net with esmtp (Exim 3.35 #1) id 1ABtWL-0003pZ-0X for pgsql-docs@postgresql.org; Tue, 21 Oct 2003 11:13:45 +0100 Received: from linda.lfix.co.uk ([192.168.1.1]) by cerberus.lfix.co.uk with esmtp (Exim 4.24) id 1ABtW8-0006PP-Po for pgsql-docs@postgresql.org; Tue, 21 Oct 2003 11:13:32 +0100 Subject: Clarification in create_function.sgml From: Oliver Elphick To: pgsql-docs@postgresql.org Content-Type: text/plain Organization: LFIX Limited Message-Id: <1066731212.5439.3.camel@linda.lfix.co.uk> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Tue, 21 Oct 2003 11:13:32 +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/24 X-Sequence-Number: 2044 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. + + Any single quotes or backslashes in the function definition must be + escaped by doubling them. + -- 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