BUG #1517: SQL interval syntax is accepted by the parser, but the interpretation is bogus

Поиск
Список
Период
Сортировка
От Roy Badami
Тема BUG #1517: SQL interval syntax is accepted by the parser, but the interpretation is bogus
Дата
Msg-id 20050302215619.7C2FDF1392@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #1517: SQL interval syntax is accepted by the parser,  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      1517
Logged by:          Roy Badami
Email address:      roy@gnomon.org.uk
PostgreSQL version: 8.0.1
Operating system:   Solaris 9
Description:        SQL interval syntax is accepted by the parser, but the
interpretation is bogus
Details:

The parser accepts SQL interval syntax, but then silently ignores it,
treating it as a zero interval.

radius=# select date '2005-01-01' + interval '1' month;
      ?column?
---------------------
 2005-01-01 00:00:00
(1 row)

radius=# select timestamp '2005-01-1 00:00:00' + interval '1' minute;
      ?column?
---------------------
 2005-01-01 00:00:00
(1 row)

radius=#

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

Предыдущее
От: "Peter Newman"
Дата:
Сообщение: BUG #1514: Inheritance and Primary Keys
Следующее
От: "Roy Badami"
Дата:
Сообщение: BUG #1518: Conversions to (undocumented) SQL year-month and day-time interval types silently discard data