Thomas Lockhart <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org