Re: Fixed length data types issue - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: Fixed length data types issue
Date
Msg-id 87lkomqh45.fsf@enterprisedb.com
Whole thread Raw
In response to Re: Fixed length data types issue  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Fixed length data types issue  (mark@mark.mielke.cc)
Re: Fixed length data types issue  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:

>> One very nifty trick would be to fix "char" to act as CHAR(), and map
>> CHAR(1) automatically to "char".
>
> Sorry, probably a stupid idea considering multi-byte encodings.  I
> suppose it could be an optimization for single-byte encodings, but that
> seems very limiting.

No, there are lots of single-byte encoding databases. And one day we'll have
per-column encoding anyways and there are lots of databases that have columns
that want to be one-character ascii encoded fields.

It's limited but I wouldn't say it's very limiting. In the cases where it
doesn't apply there's no way out anyways. A UTF8 field will need a length
header in some form.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Mid cycle release?
Next
From: Alvaro Herrera
Date:
Subject: Re: Mid cycle release?