postgres.git / summary / log / commit / refs
commit edff75bef809629c197c27b23f57baa36330d12e
Author: Peter Eisentraut <peter_e@gmx.net>
Date: Sun Jul 25 08:30:42 2010 +0000
First released in: 9.1.0, 9.0.0
Add INSERT statement to example so that it can be reproduced
from John Gage
doc/src/sgml/xfunc.sgml | 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)
diff --git a/doc/src/sgml/xfunc.sgml b/doc/src/sgml/xfunc.sgml
index b2795c2cf09..fcbf6407298 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.150 2010/07/25 08:30:42 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;
[parent: 8af787ea2491]