Re: [HACKERS] varchar() vs char16 performance - Mailing list pgsql-hackers

From Brett McCormick
Subject Re: [HACKERS] varchar() vs char16 performance
Date
Msg-id 13574.62439.864887.532887@abraxas.scene.com
Whole thread Raw
In response to Re: [HACKERS] varchar() vs char16 performance  (Hal Snyder <hal@vailsys.com>)
List pgsql-hackers

n Wed, 11 March 1998, at 11:15:34, Hal Snyder wrote:

> > The char2,4,8,16 types seem to have no value-added over the
> > better-supported char(), varchar(), text types; I am considering
> > removing them from the backend, and instead have the parser
> > transparently translate the types into varchar() (or char() - I'm not
> > certain which is a better match for the types) for v6.4. Applications
> > would not have to be changed.
> >
> > Comments?
>
> I'm not up on the details of PostgreSQL's differing character types,
> but wonder - would the proposed change break any apps where trailing
> (or leading?)  whitespace is significant?  Not that I'm running any
> ...
>

Heh.. migrating to 6.3. was a surprise for me.. I certainly wasn't
expecting whitespace pads, and there are some cases where it makes a
big difference!

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: AW: [HACKERS] varchar() vs char16 performance
Next
From: Maarten Boekhold
Date:
Subject: Re: indexing words slow