CHAR constants - Mailing list pgsql-hackers

From Thomas Lockhart
Subject CHAR constants
Date
Msg-id 3D2EF8F4.1184D813@fourpalms.org
Whole thread Raw
Responses Re: CHAR constants  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: string cast/compare broken?
Next
From: nconway@klamath.dyndns.org (Neil Conway)
Date:
Subject: test data for query optimizer