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

Поиск
Список
Период
Сортировка
От Roy Badami
Тема Re: BUG #1518: Conversions to (undocumented) SQL year-month and
Дата
Msg-id 16956.13019.283558.166931@giles.gnomon.org.uk
обсуждение исходный текст
Ответ на Re: BUG #1518: Conversions to (undocumented) SQL year-month and  (Roy Badami <roy@gnomon.org.uk>)
Ответы Re: BUG #1518: Conversions to (undocumented) SQL year-month  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-bugs
Дерево обсуждения 
Roy> I don't have a copy of the spec, but according to "A guide to
    Roy> the SQL standard" conversions like this that would discard
    Roy> data are supposed to raise an exception.

Just to clarify, my understanding is that in ANSI SQL it is valid to
convert from the data type INTERVAL YEAR TO MONTH to the data type
INTERVAL YEAR, but the conversion should raise an exception if the
value is not an integral number of years...

      -roy

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

Предыдущее
От: Roy Badami
Дата:
Сообщение: Re: BUG #1518: Conversions to (undocumented) SQL year-month and
Следующее
От: Roy Badami
Дата:
Сообщение: Re: BUG #1517: SQL interval syntax is accepted by the parser,