On Tue, Sep 1, 2009 at 11:31 PM, Rob Sargent<robjsarg...@gmail.com> 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 use with \l in psql. In 8.3 the entire "cluster" has a single collation which you can see using "show lc_collate". You can see how your system's collations work by running sort: $ LC_ALL=c sort s a.eck...@gmx.de a.fisched...@t-online.de adrianoha...@hotmail.com adx...@show.org.tw aeche...@mac.com aelef...@unina.it aeo...@hotmail.com aflores3...@gmail.com afr...@advancedneurosurgeons.com agave...@comcast.net agelsin...@amirsys.com agis1...@yahoo.gr $ LC_ALL=en_US sort s adrianoha...@hotmail.com adx...@show.org.tw aeche...@mac.com a.eck...@gmx.de aelef...@unina.it aeo...@hotmail.com a.fisched...@t-online.de aflores3...@gmail.com afr...@advancedneurosurgeons.com agave...@comcast.net agelsin...@amirsys.com agis1...@yahoo.gr -- greg http://mit.edu/~gsstark/resume.pdf -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql