Re: [GENERAL] Sorting when '*' is the initial character - solved

2005-02-08 Thread Berend Tober
> On Tue, 8 Feb 2005 01:10 pm, CoL wrote: >> 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: ---

Re: [GENERAL] Sorting when "*" is the initial character

2005-02-08 Thread Russell Smith
On Tue, 8 Feb 2005 01:10 pm, CoL wrote: > 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: > > > > > > S

Re: [GENERAL] Sorting when "*" is the initial character

2005-02-07 Thread CoL
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) ) WI

Re: [GENERAL] Sorting when "*" is the initial character

2005-02-07 Thread Stephan Szabo
On Mon, 7 Feb 2005, Berend Tober wrote: > 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: If you ran initdb with a locale such as en_US, a result like what you got is ex

Re: [GENERAL] Sorting when "*" is the initial character

2005-02-07 Thread Bruno Wolff III
On Mon, Feb 07, 2005 at 16:20:36 -0500, Berend Tober <[EMAIL PROTECTED]> wrote: > > 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_