Re: [HACKERS] numeric data type on 6.5

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: [HACKERS] numeric data type on 6.5
Дата
Msg-id 3725C990.DF9C4070@alumni.caltech.edu
обсуждение исходный текст
Ответ на Re: [HACKERS] numeric data type on 6.5  (jwieck@debis.com (Jan Wieck))
Ответы Re: [HACKERS] numeric data type on 6.5
Список pgsql-hackers
>     The  problem is that the yacc parser already tries to convert
>     it into an integer or float if you omit the quotes. I'll  try
>     to  implement  a  NUMERIC  fallback for this case for 6.6 and
>     then have all the auto conversion functionality  so  NUMERIC,
>     INTEGER and FLOAT can be used mixed.

I'm looking at this right now. I had coded in a fallback to FLOAT8 for
the integer types because at the time that was the only other useful
numeric type. However, I'm going to try changing the code to leave a
failed INTx token as a string of unspecified type, which would be
typed and converted later using the automatic coersion mechanism.

istm that this would be a no-brainer for v6.5, since it is just
replacing one heuristic with a more general and more correct one. And
I had implemented both, so we know who to blame :)

Will let y'all know how it goes...
                      - Tom

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] HSavage bug in Postgresql beta?
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: [HACKERS] RE: Mysql comparison