Re: [HACKERS] CHAR constants

2002-07-13 Thread Thomas Lockhart
> > 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

Re: [HACKERS] CHAR constants

2002-07-12 Thread Tom Lane
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 colu

[HACKERS] CHAR constants

2002-07-12 Thread Thomas Lockhart
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