CHAR constants

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема CHAR constants
Дата
Msg-id 3D2EF8F4.1184D813@fourpalms.org
обсуждение исходный текст
Ответы Re: CHAR constants  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
So, what should the behavior be of a constant declared as

CHAR 'hi'

? Right now it fails, since SQL9x asks that the char type defaults to a
length of one and our parser does not distinguish between usage as a
constant declaration and as a column definition (where you would want
the "char(1)" to be filled in). But istm that for a constant string, the
length should be whatever the string is, or unspecified.

Comments?
                    - Thomas


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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: string cast/compare broken?
Следующее
От: nconway@klamath.dyndns.org (Neil Conway)
Дата:
Сообщение: test data for query optimizer