Re: Sorting when '*' is the initial character - solved
От
Berend Tober
Тема
Re: Sorting when '*' is the initial character - solved
Дата
Msg-id
62419.216.238.112.88.1107875696.squirrel@216.238.112.88
Ответ на
Re: Sorting when "*" is the initial character (Russell Smith)
Список
Дерево обсуждения
Sorting when "*" is the initial character "Berend Tober" <btober@seaworthysys.com>
Re: Sorting when "*" is the initial character Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: Sorting when "*" is the initial character Bruno Wolff III <bruno@wolff.to>
Re: Sorting when "*" is the initial character CoL <col@mportal.hu>
Re: Sorting when "*" is the initial character Russell Smith <mr-russ@pws.com.au>
Re: Sorting when '*' is the initial character - solved "Berend Tober" <btober@seaworthysys.com>
> 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: -------------- > With 8.0.0 C local, SQL_ASCII Database, I get the expected output. > Russell Smith -------------- > order by case when account_id like '*%' then 0 else 1 end > C. Thanks. It was pointed out to me that this behavior is normal and is dependent on the locale setting.
В списке pgsql-general по дате отправления
