Re: Case-sentiveness on pgsql

2002-02-01 Thread Gordon Messmer
On Wed, 2002-01-30 at 17:42, Fernando Lozano wrote: > How to make the database permform SORT and LIKE canse-insensitive, > without having to use non-standard or not-guaranteed SQL constructs? I don't know if you can, but this mail list post: http://archives.postgresql.org/pgsql-sql/1998-09/msg00

Case-sentiveness on pgsql

2002-01-30 Thread Fernando Lozano
Hi there! Now that the accents problem is solved I have another question regarding Java and PostgreSQL (maybe just Postgres): How to make the database permform SORT and LIKE canse-insensitive, without having to use non-standard or not-guaranteed SQL constructs? Ideally, treating characters like