Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: [pgsql-advocacy] Oracle buys Innobase

Re: [pgsql-advocacy] Oracle buys Innobase

From
"Dann Corbit"
Date:
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@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Marc G. Fournier
> Sent: Wednesday, October 19, 2005 11:41 AM
> To: Richard_D_Levine@raytheon.com
> Cc: pgsql-general@postgresql.org
> Subject: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase
>
> On Wed, 19 Oct 2005, Richard_D_Levine@raytheon.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@hub.org           Yahoo!: yscrappy              ICQ:
> 7615664
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org

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

From
"Marc G. Fournier"
Date:
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@postgresql.org [mailto:pgsql-general-
>> owner@postgresql.org] On Behalf Of Marc G. Fournier
>> Sent: Wednesday, October 19, 2005 11:41 AM
>> To: Richard_D_Levine@raytheon.com
>> Cc: pgsql-general@postgresql.org
>> Subject: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase
>>
>> On Wed, 19 Oct 2005, Richard_D_Levine@raytheon.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@hub.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@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Re: [pgsql-advocacy] Oracle buys Innobase

From
Stephan Szabo
Date:
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

Doesn't that depend on the collating sequence in use, or is a NO PAD
collating sequence not allowed here?

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

From
Tino Wildenhain
Date:
Am Mittwoch, den 19.10.2005, 16:29 -0300 schrieb Marc G. Fournier:
> 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@postgresql.org [mailto:pgsql-general-
> >> owner@postgresql.org] On Behalf Of Marc G. Fournier
> >> Sent: Wednesday, October 19, 2005 11:41 AM
> >> To: Richard_D_Levine@raytheon.com
> >> Cc: pgsql-general@postgresql.org
> >> Subject: Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase
> >>
> >> On Wed, 19 Oct 2005, Richard_D_Levine@raytheon.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)


experiment=# SELECT 'a '::char = 'a  '::char;
 ?column?
----------
 t

Re: [HACKERS] 'a' == 'a ' (Was: RE: [pgsql-advocacy]

From
Tino Wildenhain
Date:
Am Mittwoch, den 19.10.2005, 22:04 +0200 schrieb Tino Wildenhain:
> Am Mittwoch, den 19.10.2005, 16:29 -0300 schrieb Marc G. Fournier:
> > I'm CC'ng this over to -hackers ... Tom?  Comments?
> >
> ...

> > >> Then we are broken too :)
> > >>
> > >> # select 'a ' = 'a  ';
> > >>   ?column?
> > >> ----------
> > >>   f
> > >> (1 row)
>
>
> experiment=# SELECT 'a '::char = 'a  '::char;
>  ?column?
> ----------
>  t
>
Sorry, copied wrong line :)

experiment=# SELECT 'a '::char(10) = 'a  '::char(10);
 ?column?
----------
 t

and:

SELECT '|' || 'foo  '::char(10) || '|';
 ?column?
----------
 |foo|


vs.


SELECT '|' || 'foo  ' || '|';
 ?column?
----------
 |foo  |