CHAR constants

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: PostgreSQL Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: CHAR constants
Date: 2002-07-12 15:42:44
Message-ID: 3D2EF8F4.1184D813@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2002-07-12 16:05:41 test data for query optimizer
Previous Message Luis Alberto Amigo Navarro 2002-07-12 15:32:50 Re: [HACKERS] please help on query