Thomas Lockhart <lockhart(at)fourpalms(dot)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