Hi, On Mar 09 02:00, Yury Don wrote: > 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
PostgreSQL relies on your locale for collation. Therefore, first you need to check if your locale settings are working. For instance: $ TEXT="a z\nad" $ echo -e $TEXT | LC_COLLATE=tr_TR.iso88599 sort ad a z $ echo -e $TEXT | LC_COLLATE=C sort a z ad Regards. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
