hi,
Berend Tober wrote, On 2/7/2005 22:20:
I encountered what looks like unusually sorting behavior, and I'm wondering if anyone can tell me if this is supposted to happen (and then if so, why) or if this is a bug:
CREATE TABLE sample_table ( account_id varchar(4), account_name varchar(25) ) WITHOUT OIDS;
INSERT INTO sample_table VALUES ('100', 'First account'); INSERT INTO sample_table VALUES ('110', 'Second account'); INSERT INTO sample_table VALUES ('120', 'Third account'); INSERT INTO sample_table VALUES ('*125', 'Fourth account'); INSERT INTO sample_table VALUES ('*115', 'Fifth account');
SELECT * FROM sample_table ORDER BY 1;
account_id,account_name 100,First account 110,Second account *115,Fifth account 120,Third account *125,Fourth account
I would expect to see
account_id,account_name *115,Fifth account *125,Fourth account 100,First account 110,Second account 120,Third account
order by case when account_id like '*%' then 0 else 1 end
C.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
