Postgres Pro
Downloads
Home   >   mailing lists

Re: case-insensitive Index - Mailing list pgsql-novice

From Verena Ruff
Subject Re: case-insensitive Index
Date
Msg-id 21160.86.59.55.246.1153323821.squirrel@v2830.vanager.de
Whole thread Raw
In response to Re: case-insensitive Index  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: case-insensitive Index
List pgsql-novice
Tree view 
Tom Lane wrote:
> If your locale is not C then you'd need to specify a special index
> opclass while creating the index in order to let it support LIKE
> queries
I didn't specify a locale when I called initdb, so it should be
postgreSQL's standard C, or? How can check the locale of a database?

Regards,
Verena Ruff

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: case-insensitive Index
Next
From: "Verena Ruff"
Date:
Subject: Re: Query optimization / automatic re-ordering of tables