diff options
| author | Neil Conway | 2004-04-23 20:32:20 +0000 |
|---|---|---|
| committer | Neil Conway | 2004-04-23 20:32:20 +0000 |
| commit | fc7fd50182f5fcec0d9c900ca8e6a48649ceb196 (patch) | |
| tree | f3d8b8a55aaef91582fd8d1a8ccada55fcbb9957 /doc/src | |
| parent | 7a66015e98e890c27e3483a413d5a88927c5b818 (diff) | |
Add ceiling() as an alias for ceil(), and power() as an alias for pow().
Regression tests and documentation have both been updated.
SQL2003 requires that both ceiling() and ceil() be present, so I have
documented both spellings. SQL2003 doesn't mention pow() as far as I
can see, so I decided to replace pow() with power() in the documentation:
there is little reason to encourage the continued usage of a function
that isn't compliant with the standard, given a standard-compliant
alternative.
RELEASE NOTES: should state that pow() is considered deprecated
(although I don't see the need to ever remove it.)
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 18 |
1 files changed, 13 insertions, 5 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 139c81effc3..9042cd394e1 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.197 2004/04/10 18:02:59 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.198 2004/04/23 20:32:19 neilc Exp $ PostgreSQL documentation --> @@ -588,6 +588,14 @@ PostgreSQL documentation </row> <row> + <entry><literal><function>ceiling</function>(<type>dp</type> or <type>numeric</type>)</literal></entry> + <entry>(same as input)</entry> + <entry>smallest integer not less than argument (alias for <function>ceil</function>)</entry> + <entry><literal>ceiling(-95.3)</literal></entry> + <entry><literal>-95</literal></entry> + </row> + + <row> <entry><literal><function>degrees</function>(<type>dp</type>)</literal></entry> <entry><type>dp</type></entry> <entry>radians to degrees</entry> @@ -654,20 +662,20 @@ PostgreSQL documentation </row> <row> - <entry><literal><function>pow</function>(<parameter>a</parameter> <type>dp</type>, + <entry><literal><function>power</function>(<parameter>a</parameter> <type>dp</type>, <parameter>b</parameter> <type>dp</type>)</literal></entry> <entry><type>dp</type></entry> <entry><parameter>a</> raised to the power of <parameter>b</parameter></entry> - <entry><literal>pow(9.0, 3.0)</literal></entry> + <entry><literal>power(9.0, 3.0)</literal></entry> <entry><literal>729</literal></entry> </row> <row> - <entry><literal><function>pow</function>(<parameter>a</parameter> <type>numeric</type>, + <entry><literal><function>power</function>(<parameter>a</parameter> <type>numeric</type>, <parameter>b</parameter> <type>numeric</type>)</literal></entry> <entry><type>numeric</type></entry> <entry><parameter>a</> raised to the power of <parameter>b</parameter></entry> - <entry><literal>pow(9.0, 3.0)</literal></entry> + <entry><literal>power(9.0, 3.0)</literal></entry> <entry><literal>729</literal></entry> </row> |