| 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: | Whole Thread | Raw Message | 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
| 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 |