Sorting when "*" is the initial character - Mailing list pgsql-general

From Berend Tober
Subject Sorting when "*" is the initial character
Date
Msg-id 63142.216.238.112.88.1107811236.squirrel@216.238.112.88
Whole thread Raw
Responses Re: Sorting when "*" is the initial character  (Bruno Wolff III <bruno@wolff.to>)
Re: Sorting when "*" is the initial character  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: Sorting when "*" is the initial character  (CoL <col@mportal.hu>)
List pgsql-general
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




pgsql-general by date:

Previous
From: "Larry Rosenman"
Date:
Subject: Re: Creating an index-type for LIKE '%value%'
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Creating an index-type for LIKE '%value%'