Обсуждение: 'a' == 'a ' (Was: RE: [pgsql-advocacy] [GENERAL] 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@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
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
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 |