From: | Terry Fielder <terry(at)ashtonwoodshomes(dot)com> |
---|---|
To: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
Cc: | Richard_D_Levine(at)raytheon(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: [pgsql-advocacy] Oracle buys Innobase |
Date: | 2005-10-19 19:37:09 |
Message-ID: | 4356A065.6000104@ashtonwoodshomes.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy 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(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
>
--
Terry Fielder
terry(at)greatgulfhomes(dot)com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
From | Date | Subject | |
---|---|---|---|
Next Message | Doug Quale | 2005-10-19 20:10:15 | Re: [pgsql-advocacy] Oracle buys Innobase |
Previous Message | Marc G. Fournier | 2005-10-19 18:40:44 | Re: [pgsql-advocacy] Oracle buys Innobase |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2005-10-19 19:39:14 | Re: [pgsql-advocacy] Oracle buys Innobase |
Previous Message | Marc G. Fournier | 2005-10-19 19:29:42 | 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buys Innobase) |