Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buysInnobase) - Mailing list pgsql-general

From Richard Huxton
Subject Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buysInnobase)
Date
Msg-id 43574B92.1040506@archonet.com
Whole thread Raw
In response to Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buysInnobase)  ("Dann Corbit" <DCorbit@connx.com>)
Responses Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buysInnobase)  (Rick Morris <rick@brainscraps.com>)
List pgsql-general
Dann Corbit wrote:
>
> I can see plenty of harm and absolutely no return.  We are talking about
> blank padding before comparison.  Do you really want 'Danniel '
> considered distinct from 'Danniel  ' in a comparison?  In real life,
> what does that buy you?

100% YES!

If two values are the same, then any function on those two values should
return the same result. Otherwise what does "equals" mean? At the very
least length() is broken by your argument.

Here it's CHAR that's broken IMHO - spawn of some punch-card spawned
data processing rules of the 70s.
--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: From oracle to postgresql...
Next
From: Hannes Dorbath
Date:
Subject: Re: Select all invalid e-mail addresses