From: Tom Lane <tgl@sss.pgh.pa.us>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: pgsql-hackers@postgreSQL.org
Subject: Simplifying varchar and bpchar behavior
Date: Fri, 23 May 2003 16:34:48 -0400
Message-ID: <18326.1053722088@sss.pgh.pa.us> (raw)
In-Reply-To: <20030513123355.B29586-100000@megazone23.bigpanda.com>
References: <20030513123355.B29586-100000@megazone23.bigpanda.com>
We have had a couple of threads recently on improving
bpchar/varchar/text behavior by making bpchar-to-text promotion
go through rtrim() (instead of being a straight binary-compatible
conversion) and getting rid of redundant operators:
http://archives.postgresql.org/pgsql-hackers/2002-11/msg00703.phphttp://archives.postgresql.org/pgsql-performance/2003-05/msg00151.php
I'm going to go ahead and make these changes for 7.4, as they will
clearly improve the intuitiveness of the behavior. I don't think they
move us any closer to spec compliance --- the spec appears to require
a notion of a collation sequence that can be specified independently
of the character datatype, which is something we don't have and aren't
likely to have very soon. (It's not clear to me that it's actually
*useful* to specify NO PAD collation with fixed-width character data,
or PAD SPACE with varchar data, but the spec lets you do it.) In the
meantime though these changes seem to be a win, and they will not leave
us any worse off when we do get around to implementing collations.
We speculated about a couple of alternative solutions in the first of
the above-mentioned threads, but they didn't look nearly as practical
to implement as this way.
Last call for objections ...
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, sszabo@megazone23.bigpanda.com, pgsql-hackers@postgreSQL.org
Subject: Re: Simplifying varchar and bpchar behavior
In-Reply-To: <18326.1053722088@sss.pgh.pa.us>
References: <20030513123355.B29586-100000@megazone23.bigpanda.com> <18326.1053722088@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox