diff options
| author | Bruce Momjian <bruce@momjian.us> | 2004-07-11 23:23:43 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2004-07-11 23:23:43 +0000 |
| commit | cf9fd800ec07f4bab09dced6b1bb2b162bdcc457 (patch) | |
| tree | ad57fe53ec346fe6470de9b2d58b0dd9480e596a /doc/src | |
| parent | af4de81469d08cc76b4da14c0b05894ce97738e2 (diff) | |
| download | postgresql-cf9fd800ec07f4bab09dced6b1bb2b162bdcc457.tar.gz postgresql-cf9fd800ec07f4bab09dced6b1bb2b162bdcc457.zip | |
Example for create function using argument names
Gavin Sherry
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_function.sgml | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml index f88bc0af956..2c43fe9b460 100644 --- a/doc/src/sgml/ref/create_function.sgml +++ b/doc/src/sgml/ref/create_function.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.57 2004/06/25 07:05:34 dennis Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.58 2004/07/11 23:23:43 momjian Exp $ --> <refentry id="SQL-CREATEFUNCTION"> @@ -400,6 +400,17 @@ CREATE FUNCTION add(integer, integer) RETURNS integer RETURNS NULL ON NULL INPUT; </programlisting> </para> + + <para> + Increment an integer, making use of an argument name, in PL/PgSQL: + +<programlisting> +CREATE OR REPLACE FUNCTION increment(i integer) RETURNS integer AS ' + BEGIN + RETURN i + 1; + END;' LANGUAGE plpgsql; +</programlisting> + </para> </refsect1> |