Re: [SQL] Non-standard function names

2004-06-23 Thread Tom Lane
Clive Page <[EMAIL PROTECTED]> writes: > The problems come with LN and LOG which Postgres uses for logarithms to > base e and 10 respectively: the JDBC standard uses LOG and LOG10 > respectively, so that any fix would mean LOG changed its meaning. I don't > see an easy solution here; maybe both LO

[SQL] Non-standard function names

2004-06-23 Thread Clive Page
The developers of Postgres over the years are to be commended on their support for SQL Standards, but one thing that has annoyed me for some time is that the names of several mathematical functions are seriously non-standard. Postgres isn't actually flouting an SQL Standard in this area as there i