| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | <terry(at)ashtonwoodshomes(dot)com>, <DCorbit(at)connx(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org>, <pgsql-hackers(at)postgresql(dot)org>, <scrappy(at)postgresql(dot)org>, <Richard_D_Levine(at)raytheon(dot)com>, <tino(at)wildenhain(dot)de> |
| Subject: | Re: [HACKERS] 'a' == 'a ' (Was: RE: [pgsql-advocacy] |
| Date: | 2005-10-20 14:53:37 |
| Message-ID: | 43576921020000250000015A@gwmta.wicourts.gov |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Dann Corbit wrote:
> Try this query in Oracle, SQL*Server, DB/2, Informix, etc.:
>
> connxdatasync=# select 1 where cast('a' as varchar(30)) = cast('a ' as
> varchar(30));
> ?column?
> ----------
> (0 rows)
For what it's worth, on Sybase ASE I get:
-----------
1
(1 row affected)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrus | 2005-10-20 15:10:40 | Re: Select all invalid e-mail addresses |
| Previous Message | Lincoln Yeoh | 2005-10-20 14:47:00 | Re: [HACKERS] 'a' == 'a ' |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 沈一枫 | 2005-10-20 14:55:39 | what is the hash function ' s main idea in tsearch2? |
| Previous Message | Lincoln Yeoh | 2005-10-20 14:47:00 | Re: [HACKERS] 'a' == 'a ' |