String Comparison / Embedded Spaces

From: Ken Schenke <kschenke(at)datafreight(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: String Comparison / Embedded Spaces
Date: 2003-07-22 19:01:40
Message-ID: 3F1D8A14.1010501@datafreight.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

--
Ken Schenke

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gould 2003-07-22 19:04:29 Re: comparing database schema's
Previous Message Dennis Gearon 2003-07-22 18:57:16 Re: New Poll @ Codewalkers