Re: BUG #1518: Conversions to (undocumented) SQL year-month and

Поиск
Список
Период
Сортировка
От Roy Badami
Тема Re: BUG #1518: Conversions to (undocumented) SQL year-month and
Дата
Msg-id 16961.56392.618908.323750@giles.gnomon.org.uk
обсуждение исходный текст
Ответ на Re: BUG #1518: Conversions to (undocumented) SQL year-month and  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: BUG #1518: Conversions to (undocumented) SQL year-month and  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-bugs
Bruce> Seems that is implentation-dependent so I added "round' or
    Bruce> error" to the TODO item.

Ah, OK.  "A guide to the SQL standard" claims it's an exception, but I
haven't checked the actual standard.

    Bruce> Uh, I think this already works fine for PG syntax, and I
    Bruce> assume once we support ANSI syntax it will work fine too:

I guess.  It's just that it's something that EXTRACT doesn't currently
have to worry about, so it would be easy to overlook.

      -roy

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

Предыдущее
От: Sergio Lob
Дата:
Сообщение: Re: Precision and scale of numeric column reported as value
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Precision and scale of numeric column reported as value