Re: String Comparison / Embedded Spaces
От | Ron Johnson |
---|---|
Тема | Re: String Comparison / Embedded Spaces |
Дата | |
Msg-id | 1058945344.19042.1048.camel@haggis обсуждение исходный текст |
Ответ на | Re: String Comparison / Embedded Spaces (Stephan Szabo <sszabo@megazone.bigpanda.com>) |
Список | pgsql-general |
On Wed, 2003-07-23 at 00:46, Stephan Szabo wrote: > On Tue, 22 Jul 2003, Ken Schenke wrote: > > > Does the PostgreSQL string comparison operator remove embedded spaces in > > a string before comparing? Here is a query I'm issuing (notice the > > space between A and C in the first string): > > > > select version(); > > select ('A C' < 'AB') as result; > > > > the result that comes back is: > > > > version > > > > ----------------------------------------------------------------------- > > PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 > > 20030222 (Red Hat Linux 3.2.2-5) > > > > result > > ------ > > f > > > > I searched the list archives and could not find a mention of this. > > Shouldn't the result of the comparison be true, not false? > > That depends on the locale you have set for collation. If it's en_US > (for example) spaces and some symbols don't act like you'd expect. > 'AB' < 'A B' < 'AC' < 'A C' I believe. My system is definitely C locale. template1=# select version(); version ------------------------------------------------------------------------- PostgreSQL 7.3.3 on i386-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3 (Debian) (1 row) template1=# select ('A C' < 'AB') as result; result -------- t (1 row) -- +-----------------------------------------------------------------+ | Ron Johnson, Jr. Home: ron.l.johnson@cox.net | | Jefferson, LA USA | | | | "I'm not a vegetarian because I love animals, I'm a vegetarian | | because I hate vegetables!" | | unknown | +-----------------------------------------------------------------+
В списке pgsql-general по дате отправления: