X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2A69FDB8DE; Tue, 15 Nov 2005 20:20:46 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37389-06; Wed, 16 Nov 2005 00:20:46 +0000 (GMT) X-Greylist: delayed 01:21:25.056459 by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 8C425DB81F; Tue, 15 Nov 2005 20:20:29 -0400 (AST) Received: from mail1.utiba.com (eth2643.vic.adsl.internode.on.net [150.101.158.82]) by svr2.postgresql.org (Postfix) with ESMTP id 59A97F0C1C; Tue, 15 Nov 2005 22:59:16 +0000 (GMT) Received: from rotate-the-shield-harmonics.utiba.com (localhost [127.0.0.1]) by mail1.utiba.com (Postfix) with ESMTP id 50C2313ECD8; Wed, 16 Nov 2005 09:59:24 +1100 (EST) From: Philip Yarra To: pgsql-patches@postgresql.org, pgsql-docs@postgresql.org Subject: pl/pgSQL doco patch Date: Wed, 16 Nov 2005 09:59:04 +1100 User-Agent: KMail/1.7.2 Organization: Utiba Pty Ltd X-enigma: Naturally a smoked function is living MIME-Version: 1.0 Content-Type: Multipart/Mixed; boundary="Boundary-00=_4gmeDv72sKEbcK0" Message-Id: <200511160959.04771.philip@utiba.com> X-Utiba-MailScanner-Information: Please contact the Systems Administrator at Utiba for more information X-Utiba-MailScanner: Found to be clean Utiba-MailScanner-MCPCheck: X-MailScanner-From: philip@utiba.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/26 X-Sequence-Number: 3336 --Boundary-00=_4gmeDv72sKEbcK0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, I supplied a minor doco patch relating to porting pl/SQL to pl/pgSQL: http://archives.postgresql.org/pgsql-hackers/2005-10/msg01295.php. Also attached here. Could someone please review and apply this for me? Regards, Philip. -- "Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it." - Brian W. Kernighan ----------------- Utiba Pty Ltd This message has been scanned for viruses and dangerous content by Utiba mail server and is believed to be clean. --Boundary-00=_4gmeDv72sKEbcK0 Content-Type: text/x-diff; charset="us-ascii"; name="doc-plpgsql-oraport.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="doc-plpgsql-oraport.patch" Index: doc/src/sgml/plpgsql.sgml =================================================================== RCS file: /projects/cvsroot/pgsql/doc/src/sgml/plpgsql.sgml,v retrieving revision 1.79 diff -c -r1.79 plpgsql.sgml *** doc/src/sgml/plpgsql.sgml 21 Oct 2005 05:11:23 -0000 1.79 --- doc/src/sgml/plpgsql.sgml 28 Oct 2005 05:20:54 -0000 *************** *** 3132,3137 **** --- 3132,3144 ---- state in temporary tables, instead. + + + You cannot use parameter names that are the same as columns + that are referenced in the function. Oracle does allow you to do this + if you qualify the parameter name as function_name.paramater_name + + --Boundary-00=_4gmeDv72sKEbcK0--