Re: [SQL] char type seems the same as char(1)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: lockhart(at)alumni(dot)caltech(dot)edu, pgsql-sql(at)hub(dot)org
Subject: Re: [SQL] char type seems the same as char(1)
Date: 1998-12-13 17:14:10
Message-ID: 22059.913569250@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> writes:
> Should I add this to the TODO list, that char is not char1 but has
> 4-byte length?

Well, Tom Lockhart responded that "it's not a bug, it's a feature".
I still think it's broken --- and certainly the fact that quoting
affects the result (char and "char" act differently) is not good.
But the discussion seems to have died out without producing any
definite plan of action.

regards, tom lane

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 1998-12-13 19:31:37 Re: [SQL] char type seems the same as char(1)
Previous Message Bruce Momjian 1998-12-13 04:33:18 Re: [SQL] ' escape