X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 330315286A
	for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
	Thu, 19 May 2005 21:07:26 -0300 (ADT)
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 37514-06
	for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
	Fri, 20 May 2005 00:07:21 +0000 (GMT)
Received: from fetter.org (dsl092-188-065.sfo1.dsl.speakeasy.net
	[66.92.188.65])
	by svr1.postgresql.org (Postfix) with ESMTP id 2A4725284D
	for <pgsql-docs@postgresql.org>; Thu, 19 May 2005 21:07:19 -0300 (ADT)
Received: from fetter.org (localhost.localdomain [127.0.0.1])
	by fetter.org (8.13.1/8.12.10) with ESMTP id j4K07XcA020073
	for <pgsql-docs@postgresql.org>; Thu, 19 May 2005 17:07:33 -0700
Received: (from shackle@localhost)
	by fetter.org (8.13.1/8.13.1/Submit) id j4K07X43020072
	for pgsql-docs@postgresql.org; Thu, 19 May 2005 17:07:33 -0700
Date: Thu, 19 May 2005 17:07:33 -0700
From: David Fetter <david@fetter.org>
To: PostgreSQL Docs <pgsql-docs@postgresql.org>
Subject: Add cross references for CREATE FUNCTION to PLs
Message-ID: <20050520000733.GA15525@fetter.org>
Mime-Version: 1.0
Content-Type: multipart/mixed; boundary="2fHTh5uZTiUOsy+g"
Content-Disposition: inline
User-Agent: Mutt/1.4.2i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.058 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200505/29
X-Sequence-Number: 2994


--2fHTh5uZTiUOsy+g
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

Folks,

Please find enclosed a patch which adds cross-references to the CREATE
FUNCTION syntax in the PL/* docs.

Cheers,
D
-- 
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

--2fHTh5uZTiUOsy+g
Content-Type: text/plain; charset=us-ascii
Content-Disposition: attachment; filename="create_function.diff"

Index: doc/src/sgml/plperl.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/plperl.sgml,v
retrieving revision 2.39
diff -c -r2.39 plperl.sgml
*** doc/src/sgml/plperl.sgml	9 Apr 2005 03:52:43 -0000	2.39
--- doc/src/sgml/plperl.sgml	20 May 2005 00:02:47 -0000
***************
*** 44,50 ****
    <title>PL/Perl Functions and Arguments</title>
  
    <para>
!    To create a function in the PL/Perl language, use the standard syntax:
  <programlisting>
  CREATE FUNCTION <replaceable>funcname</replaceable> (<replaceable>argument-types</replaceable>) RETURNS <replaceable>return-type</replaceable> AS $$
      # PL/Perl function body
--- 44,51 ----
    <title>PL/Perl Functions and Arguments</title>
  
    <para>
!    To create a function in the PL/Perl language, use the standard
! syntax (<xref linkend="sql-createfunction">):
  <programlisting>
  CREATE FUNCTION <replaceable>funcname</replaceable> (<replaceable>argument-types</replaceable>) RETURNS <replaceable>return-type</replaceable> AS $$
      # PL/Perl function body
Index: doc/src/sgml/plpgsql.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/plpgsql.sgml,v
retrieving revision 1.67
diff -c -r1.67 plpgsql.sgml
*** doc/src/sgml/plpgsql.sgml	19 Apr 2005 03:55:43 -0000	1.67
--- doc/src/sgml/plpgsql.sgml	20 May 2005 00:02:50 -0000
***************
*** 53,61 ****
      Except for input/output conversion and calculation functions
      for user-defined types, anything that can be defined in C language
      functions can also be done with <application>PL/pgSQL</application>.
!     For example, it is possible to
!     create complex conditional computation functions and later use
!     them to define operators or use them in index expressions.
     </para>
  
    <sect1 id="plpgsql-overview">
--- 53,61 ----
      Except for input/output conversion and calculation functions
      for user-defined types, anything that can be defined in C language
      functions can also be done with <application>PL/pgSQL</application>.
!     For example, it is possible to create complex conditional
!     computation functions (<xref linkend="sql-createfunction">) and
!     later use them to define operators or use them in index expressions.
     </para>
  
    <sect1 id="plpgsql-overview">
Index: doc/src/sgml/plpython.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/plpython.sgml,v
retrieving revision 1.28
diff -c -r1.28 plpython.sgml
*** doc/src/sgml/plpython.sgml	9 Apr 2005 03:52:43 -0000	1.28
--- doc/src/sgml/plpython.sgml	20 May 2005 00:02:50 -0000
***************
*** 46,52 ****
    <title>PL/Python Functions</title>
  
    <para>
!    Functions in PL/Python are declared in the usual way, for example
  <programlisting>
  CREATE FUNCTION myfunc(text) RETURNS text
      AS 'return args[0]'
--- 46,53 ----
    <title>PL/Python Functions</title>
  
    <para>
!    Functions in PL/Python are declared in the usual way
!     (<xref linkend="sql-createfunction">), for example
  <programlisting>
  CREATE FUNCTION myfunc(text) RETURNS text
      AS 'return args[0]'
Index: doc/src/sgml/pltcl.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/pltcl.sgml,v
retrieving revision 2.37
diff -c -r2.37 pltcl.sgml
*** doc/src/sgml/pltcl.sgml	9 Apr 2005 03:52:43 -0000	2.37
--- doc/src/sgml/pltcl.sgml	20 May 2005 00:02:51 -0000
***************
*** 75,81 ****
      <title>PL/Tcl Functions and Arguments</title>
  
      <para>
!      To create a function in the <application>PL/Tcl</> language, use the standard syntax:
  
  <programlisting>
  CREATE FUNCTION <replaceable>funcname</replaceable> (<replaceable>argument-types</replaceable>) RETURNS <replaceable>return-type</replaceable> AS $$
--- 75,82 ----
      <title>PL/Tcl Functions and Arguments</title>
  
      <para>
!      To create a function in the <application>PL/Tcl</> language, use
! the standard syntax (<xref linkend="sql-createfunction">):
  
  <programlisting>
  CREATE FUNCTION <replaceable>funcname</replaceable> (<replaceable>argument-types</replaceable>) RETURNS <replaceable>return-type</replaceable> AS $$

--2fHTh5uZTiUOsy+g--