Re: [SQL] char type seems the same as char(1) - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] char type seems the same as char(1)
Date
Msg-id 22059.913569250@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] char type seems the same as char(1)  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [SQL] char type seems the same as char(1)  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-sql
Bruce Momjian <maillist@candle.pha.pa.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

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] ' escape
Next
From: Bruce Momjian
Date:
Subject: Re: [SQL] char type seems the same as char(1)