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