Re: BUG #1517: SQL interval syntax is accepted by the parser,
От | Tom Lane |
---|---|
Тема | Re: BUG #1517: SQL interval syntax is accepted by the parser, |
Дата | |
Msg-id | 12829.1111210543@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: BUG #1517: SQL interval syntax is accepted by the parser, (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
Re: BUG #1517: SQL interval syntax is accepted by the parser,
Re: BUG #1517: SQL interval syntax is accepted by the parser, |
Список | pgsql-bugs |
Bruce Momjian <pgman@candle.pha.pa.us> writes: > Well, that certainly belongs in the 'bizarre' category. It should not > accept that syntax. It should require the 'month' or 'minute' to be in > single quotes. No, it shouldn't; read the SQL spec. AFAICS the syntax select interval '1' month is perfectly spec-compliant. The variant select interval '1 month' is *not* per-spec, it is a Postgres-ism. Tom Lockhart was working on this stuff shortly before he decided that raising horses was a more interesting use of his spare time. It doesn't look like he ever quite finished. I tried several back versions of Postgres to see if it had ever operated correctly and the answer seems to be "no" :-( ... although we have managed to fail in more than one way over the years ... regards, tom lane
В списке pgsql-bugs по дате отправления: