2009/4/5 Félix Sánchez Rodríguez <fesanch@xxxxxxxxxxxxx>: > Greetings: > > I need to be able to establish which fields of my tables are and which are > not case sensitive. Is it possible?? How?? In what way, in how you refer to them or in how you compare them? PostgreSQL has no built in case-insensitive types, but there is an addon for citext or something like it that makes a case insensitive type. Or you can make a case insensitive index and use that. create table mytable (id int, field x int, fieldy int, field1 text); create index mytable_field1 on mytable ((lower(field))); select * from mytable where lower(field)='abc'; -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
