I guess you can create a unique functional index with upper as the function. Try to look up the docs for CREATE INDEX. HTH, Csaba. On Wed, 2005-09-21 at 18:15, Andrus wrote: > I want to disable dupplicate customer names in a database regardless to > case. > > I tried > > CREATE TABLE customer ( id SERIAL, name CHARACTER(70)); > > ALTER TABLE customer > ADD constraint customer_name_unique UNIQUE (UPPER(name)); > > but this is not allowed in Postgres > > Any idea ? > > Andrus. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
