Re: NUMERIC key word

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: NUMERIC key word
Дата
Msg-id 11544.1202686632@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: NUMERIC key word  (Neil Conway <neilc@samurai.com>)
Список pgsql-patches
Neil Conway <neilc@samurai.com> writes:
> On Tue, 2008-01-29 at 13:20 -0500, Tom Lane wrote:
>> The reason it was kept was to override the search path --- unqualified
>> NUMERIC will always be taken as pg_catalog.numeric even if you have some
>> other type "numeric" in front of it.

> It should be possible to implement this behavior without requiring
> NUMERIC to be a keyword, though.

Perhaps we could find some other, even uglier kludge ... I doubt it
would be an improvement.  Is there any particular reason NUMERIC
*shouldn't* be a keyword?  It's called out as a <reserved word> by
the spec, after all.  (In fact, I seem to recall that it was exactly
that point that made us decide that the implicit conversion to
pg_catalog.numeric was appropriate.)

            regards, tom lane

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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: NUMERIC key word
Следующее
От: Hans-Juergen Schoenig
Дата:
Сообщение: Endless recovery