diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2010-07-25 08:30:41 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2010-07-25 08:30:41 +0000 |
| commit | c12c561ba05610a680bb3d58f1ec5c98575ae0c7 (patch) | |
| tree | cd1d0a4e33e6b3a6e0828e46a4d6227d9689f8ba /doc/src | |
| parent | 8dad931f4e9433b74f1a6e40ff24bbc766e1a17f (diff) | |
Add INSERT statement to example so that it can be reproduced
from John Gage
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/xfunc.sgml | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/doc/src/sgml/xfunc.sgml b/doc/src/sgml/xfunc.sgml index b2795c2cf09..e728eb30640 100644 --- a/doc/src/sgml/xfunc.sgml +++ b/doc/src/sgml/xfunc.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/xfunc.sgml,v 1.149 2010/05/30 18:10:40 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/xfunc.sgml,v 1.149.2.1 2010/07/25 08:30:41 petere Exp $ --> <sect1 id="xfunc"> <title>User-Defined Functions</title> @@ -293,6 +293,8 @@ CREATE TABLE emp ( cubicle point ); +INSERT INTO emp VALUES ('Bill', 4200, 45, '(2,1)'); + CREATE FUNCTION double_salary(emp) RETURNS numeric AS $$ SELECT $1.salary * 2 AS salary; $$ LANGUAGE SQL; |