Rob Sargent wrote:
I'm sure this a life-time's worth of discussion on the merits of
treating "."
as nothing when sorting
Well, every sorted reference work in society at large seems to have a
different idea of how to sort - just compare the phone book to the dictionary.
That's the point
OK, I'm waking up now. My locale is as Scott suspected, en-US.UTF-8,
and of
course my server too.
I guess I never really left "C" intellectually :) and we have a server that
thinks SQL-ASCII is cool and comparing lists of names and emails between
that server
and my local utf-8 one was rather
On Tue, Sep 1, 2009 at 11:31 PM, Rob Sargent wrote:
> How many ways might one accidentally do that I wonder.
Well most operating system distributions ask you when you install them
what region you're in and use a collation for that region.
In 8.4 you can check what collation a database is set to u
How many ways might one accidentally do that I wonder.
Scott Marlowe wrote:
On Tue, Sep 1, 2009 at 3:01 PM, Rob Sargent wrote:
Since when does "." sort as "nothing at all"
Since you set your locale equal to something like en_US instead of C
--
Sent via pgsql-sql mailing list (pgs
On Tue, Sep 1, 2009 at 3:01 PM, Rob Sargent wrote:
> Since when does "." sort as "nothing at all"
Since you set your locale equal to something like en_US instead of C
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mai
Since when does "." sort as "nothing at all"
This select
select
distinct u.user_name
from
subscriber_user u,
subscription s,
subscription_template t
where
u.id = s.subscriber_entity_id
and s.template_id = t.id
a