diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-11-01 21:09:51 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-11-01 21:09:51 +0000 |
commit | b524cb36ac2526049fe7978cadc28fca647f9b70 (patch) | |
tree | bcf62e8144f037d97f533b7be740ba0f1bb0a8c6 /doc/src/sgml/ref/create_function.sgml | |
parent | cad0e824a0eacab21210901a394e7f322fc0508a (diff) | |
download | postgresql-b524cb36ac2526049fe7978cadc28fca647f9b70.tar.gz postgresql-b524cb36ac2526049fe7978cadc28fca647f9b70.zip |
Make an editorial pass over the reference pages.
Diffstat (limited to 'doc/src/sgml/ref/create_function.sgml')
-rw-r--r-- | doc/src/sgml/ref/create_function.sgml | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml index 785f8bbb708..022a26c6b09 100644 --- a/doc/src/sgml/ref/create_function.sgml +++ b/doc/src/sgml/ref/create_function.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.66 2005/07/14 06:17:36 neilc Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.67 2005/11/01 21:09:50 tgl Exp $ --> <refentry id="SQL-CREATEFUNCTION"> @@ -228,9 +228,9 @@ CREATE [ OR REPLACE ] FUNCTION change even within a single table scan, so no optimizations can be made. Relatively few database functions are volatile in this sense; some examples are <literal>random()</>, <literal>currval()</>, - <literal>timeofday()</>. Note that any function that has side-effects - must be classified volatile, even if its result is quite predictable, - to prevent calls from being optimized away; an example is + <literal>timeofday()</>. But note that any function that has + side-effects must be classified volatile, even if its result is quite + predictable, to prevent calls from being optimized away; an example is <literal>setval()</>. </para> @@ -279,9 +279,9 @@ CREATE [ OR REPLACE ] FUNCTION </para> <para> - The key word <literal>EXTERNAL</literal> is present for SQL - conformance but is optional since, unlike in SQL, this feature - does not only apply to external functions. + The key word <literal>EXTERNAL</literal> is allowed for SQL + conformance, but it is optional since, unlike in SQL, this feature + applies to all functions not only external ones. </para> </listitem> </varlistentry> @@ -478,7 +478,7 @@ SELECT * FROM dup(42); <title>Compatibility</title> <para> - A <command>CREATE FUNCTION</command> command is defined in SQL:2003. + A <command>CREATE FUNCTION</command> command is defined in SQL:1999 and later. The <productname>PostgreSQL</productname> version is similar but not fully compatible. The attributes are not portable, neither are the different available languages. |