Re: CHAR constants

Thomas Lockhart <lockhart@fourpalms.org> writes:
> 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.

Seems we should convert that to char(2).  Not sure how difficult it is
to do though...
        regards, tom lane