This patch makes the following changes:

(1) Add ceiling() as an alias for ceil() (both double precision and numeric variants). This is required by SQL2003, so both spellings of the function name have been documented.

(2) Add power() as an alias for pow(). SQL2003 only defines power() AFAICS. Rather than documenting two identical spellings of the same command, I think it makes sense to migrate toward the spelling that is preferred by the standard. Therefore, I renamed the documentation for pow() to refer to power().

I didn't remove pow(): that would break far too much existing code, and there is little harm in keeping around an additional pg_proc entry or two. I think that keeping pow() but not documenting it should ensure that new users prefer power() but older applications do not need to be changed, which is a reasonable compromise between backward compatibility and forward progress.

Regression tests are included (I believe I updated all the variants of float8 properly, but please speak up if that is not the case). This patch bumps the catalog version number.

Barring any objections, I intend to apply this within 24 hours.


Attachment: ceiling_func-3.patch
Description: Binary data

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to