| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Dann Corbit <DCorbit(at)connx(dot)com> |
| Cc: | Terry Fielder <terry(at)ashtonwoodshomes(dot)com>, Tino Wildenhain <tino(at)wildenhain(dot)de>, "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, Richard_D_Levine(at)raytheon(dot)com, pgsql-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buysInnobase) |
| Date: | 2005-10-20 07:47:30 |
| Message-ID: | 43574B92.1040506@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannes Dorbath | 2005-10-20 08:05:46 | Re: Select all invalid e-mail addresses |
| Previous Message | Richard Huxton | 2005-10-20 07:38:22 | Re: From oracle to postgresql... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2005-10-20 08:38:05 | Re: changing create table |
| Previous Message | Varun Shingal | 2005-10-20 07:46:00 | changing create table |