aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2004-01-24 22:05:08 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2004-01-24 22:05:08 +0000
commit0152f148129ce5f77d1af0f69c6a0dece7c20398 (patch)
tree2b6d6dd90b4fa8383e281dec391dc094f91f3ee1
parent6f046b9d9f6c0727fc72dafe869dba9bc015a8ea (diff)
downloadpostgresql-0152f148129ce5f77d1af0f69c6a0dece7c20398.tar.gz
postgresql-0152f148129ce5f77d1af0f69c6a0dece7c20398.zip
Example of a function taking a composite type should show how to call it.
-rw-r--r--doc/src/sgml/plpgsql.sgml4
1 files changed, 3 insertions, 1 deletions
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml
index 30f7f3c4802..0e7f7ad5d0a 100644
--- a/doc/src/sgml/plpgsql.sgml
+++ b/doc/src/sgml/plpgsql.sgml
@@ -1,5 +1,5 @@
<!--
-$PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.33 2004/01/22 19:50:21 neilc Exp $
+$PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.34 2004/01/24 22:05:08 tgl Exp $
-->
<chapter id="plpgsql">
@@ -685,6 +685,8 @@ BEGIN
RETURN in_t.f1 || use_t.f3 || in_t.f5 || use_t.f7;
END;
' LANGUAGE plpgsql;
+
+SELECT use_two_tables(t.*) FROM tablename t WHERE ... ;
</programlisting>
</para>
</sect2>