Re: [SQL] Specifying column level collations

2011-05-07 Thread Thomas Kellerer
Tom Lane wrote on 07.05.2011 18:48: Thomas Kellerer writes: My database is initialized as follows: postgres=# select version(); version PostgreSQL 9.1beta1, compiled by Visual C++ build 1500, 32

Re: [SQL] Specifying column level collations

2011-05-07 Thread Tom Lane
Thomas Kellerer writes: > My database is initialized as follows: > postgres=# select version(); > version > > PostgreSQL 9.1beta1, compiled by Visual C++ build 1500, 32-bit > (1 row) I gather this is

Re: [SQL] Specifying column level collations

2011-05-07 Thread Thomas Kellerer
Guillaume Lelarge wrote on 07.05.2011 14:02: create table foo (bar text collate "fr_FR") --> collation "fr_FR" for encoding "UTF8" does not exist create table foo (bar text collate "fr_FR.1252") --> collation "fr_FR" for encoding "UTF8" does not exist create table foo (bar text collate "fr_

Re: [SQL] Specifying column level collations

2011-05-07 Thread Guillaume Lelarge
On 05/07/2011 01:19 PM, Thomas Kellerer wrote: > Hi, > > I'm playing around with 9.1beta1 and would like to create a table where > one column has a non-default collation. > > But whatever I try, I can't find the correct name that I have to use. > > My database is initialized as follows: > > pos

[SQL] Specifying column level collations

2011-05-07 Thread Thomas Kellerer
Hi, I'm playing around with 9.1beta1 and would like to create a table where one column has a non-default collation. But whatever I try, I can't find the correct name that I have to use. My database is initialized as follows: postgres=# select version(); version ---