Skip site navigation (1) Skip section navigation (2)

BUG #2309: Wrong string comparison

From: "Yury Don" <yura(at)vpcit(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2309: Wrong string comparison
Date: 2006-03-09 14:00:53
Message-ID: 20060309140053.ED78CF0B08@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2309
Logged by:          Yury Don
Email address:      yura(at)vpcit(dot)ru
PostgreSQL version: 8.1.3
Operating system:   Linux (Debian)
Description:        Wrong string comparison
Details: 

Looks like string comparison operators ignore spaces isnside of string.
Because of this sorting on text fields is wrong.

mdb=# select 'a z'::text>'ad'::text;
 ?column?
----------
 t

Responses

pgsql-bugs by date

Next:From: MarceloDate: 2006-03-09 14:52:40
Subject: Suse Installations
Previous:From: Stefan MiefertDate: 2006-03-09 13:27:05
Subject: [postgres] Postgres auf Ubuntu installieren

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group