|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.57 2004/06/25 07:05:34 dennis Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.58 2004/07/11 23:23:43 momjian Exp $ |
3 | 3 | --> |
4 | 4 |
|
5 | 5 | <refentry id="SQL-CREATEFUNCTION"> |
@@ -398,6 +398,17 @@ CREATE FUNCTION add(integer, integer) RETURNS integer |
398 | 398 | LANGUAGE SQL |
399 | 399 | IMMUTABLE |
400 | 400 | RETURNS NULL ON NULL INPUT; |
| 401 | +</programlisting> |
| 402 | + </para> |
| 403 | + |
| 404 | + <para> |
| 405 | + Increment an integer, making use of an argument name, in PL/PgSQL: |
| 406 | + |
| 407 | +<programlisting> |
| 408 | +CREATE OR REPLACE FUNCTION increment(i integer) RETURNS integer AS ' |
| 409 | +BEGIN |
| 410 | +RETURN i + 1; |
| 411 | +END;' LANGUAGE plpgsql; |
401 | 412 | </programlisting> |
402 | 413 | </para> |
403 | 414 | </refsect1> |
|