'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buys Innobase)

I'm CC'ng this over to -hackers ... Tom? Comments?

On Wed, 19 Oct 2005, Dann Corbit wrote:

> Yes, clearly that is the wrong result according to the SQL standard.
>
> Here is a SQL*Server query:
> select 1 where 'a' = 'a ' AND 'a' = 'a ' AND 'a ' = 'a '
>
> It returns (correctly): 1
>
>> -----Original Message-----
>> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
>> owner(at)postgresql(dot)org] On Behalf Of Marc G. Fournier
>> Sent: Wednesday, October 19, 2005 11:41 AM
>> To: Richard_D_Levine(at)raytheon(dot)com
>> Cc: pgsql-general(at)postgresql(dot)org
>> Subject: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase
>>
>> On Wed, 19 Oct 2005, Richard_D_Levine(at)raytheon(dot)com wrote:
>>
>>> I was referring to trailing blanks, but did not explicitly say it,
>>> though showed it in the examples. I am pretty sure that the SQL
>>> standard says that trailing whitespace is insignificant in string
>>> comparison.
>>
>> Then we are broken too :)
>>
>> # select 'a ' = 'a ';
>> ?column?
>> ----------
>> f
>> (1 row)
>>
>> ----
>> Marc G. Fournier Hub.Org Networking Services
>> (http://www.hub.org)
>> Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ:
>> 7615664
>>
>> ---------------------------(end of
> broadcast)---------------------------
>> TIP 4: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664