On Tue, Nov 2, 2010 at 8:40 AM, Euler Taveira de Oliveira <eu...@timbira.com> wrote: > Alexandre Riveira escreveu: >> I've achieved some success in changing collate operating system (linux) >> to generate sort of way of Brazil Portuguese hopes by adding the >> following code in LC_COLLATE >> > This was already discussed; search the archives [1] [2]. > >> So far, I understood the mechanism of change collate and reproduce in >> postgresql, and I could not generate a case-insensitive search, I >> believe that would change within the LC_COLLATE variable, but could not >> go any further than that. >> > PostgreSQL doesn't support case-insensitive searches specifying the collate > per column yet. Look at [3]. But you could use ILIKE or regular expression to > achieve that.
Is citext also useful for this? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers