Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle
Дата
Msg-id 29449.1226192433@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle  (Chuck McDevitt <cmcdevitt@greenplum.com>)
Список pgsql-hackers
Chuck McDevitt <cmcdevitt@greenplum.com> writes:
> Doesn't ANSI standard interval syntax have the minus sign before the quotes?
> Select interval -'2008-10';

They allow it either there or inside the quotes.

We can't support outside-the-quotes unless we make INTERVAL a fully
reserved word (and even then there are syntactic problems :-().

Putting the minus sign before INTERVAL works fine btw ...
        regards, tom lane


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

Предыдущее
От: Chuck McDevitt
Дата:
Сообщение: Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle
Следующее
От: Tom Lane
Дата:
Сообщение: Re: WIP: Page space reservation (pgupgrade)