Commitcf9fd80

committed

Example for create function using argument names

Gavin Sherry

1 parentaf4de81 commitcf9fd80Copy full SHA for cf9fd80

File tree

+12

-1

lines changed

+12

-1

lines changed

Lines changed: 12 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`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>`

Comments

(0)