Re: [pgsql-advocacy] Oracle buys Innobase

Terry Fielder <terry@ashtonwoodshomes.com>

From: Terry Fielder <terry@ashtonwoodshomes.com>
To: "Marc G. Fournier" <scrappy@postgresql.org>
Cc: Richard_D_Levine@raytheon.com, pgsql-general@postgresql.org
Date: 2005-10-19T19:37:09Z
Lists: pgsql-general
OK, I am not an expert on the SQL standard, but I thought the definition 
varied by data type e.g. varchar <> bpchar

Terry

Marc G. Fournier wrote:
> 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
> 

-- 
Terry Fielder
terry@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085