diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2004-01-24 22:05:08 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2004-01-24 22:05:08 +0000 |
commit | 0152f148129ce5f77d1af0f69c6a0dece7c20398 (patch) | |
tree | 2b6d6dd90b4fa8383e281dec391dc094f91f3ee1 | |
parent | 6f046b9d9f6c0727fc72dafe869dba9bc015a8ea (diff) | |
download | postgresql-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.sgml | 4 |
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> |