Re: TRUNC vs. TRUNCATE

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: TRUNC vs. TRUNCATE
Дата
Msg-id 200511282245.jASMj3K24883@candle.pha.pa.us
обсуждение исходный текст
Ответ на TRUNC vs. TRUNCATE  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-hackers
Christopher Kings-Lynne wrote:
> Hi,
> 
> I notice we added CEILING() as an alias to CEIL() for compatibility.  We 
> also have POWER() for POW().
> 
> I notice that MySQL uses TRUNCATE() and we only have TRUNC().  Is 
> TRUNCATE actually spec compliant?  Should we add TRUNCATE anyway for 

I don't see either in the SQL99 standard.

> consistency and compatibility?

No, if we did that we would be carrying around a ton of stuff.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: POWER vs. POW ???
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: NVL vs COALESCE