Hi, is there a way to define a unique restraint on UPPER (textfield)?
E.g. mytable (
name_id serial PRIMARY KEY, name varchar(255), UNIQUE ( upper (name) ) ) psql throws a syntax error because of the upper() function.I need to prohibit that 2 of strings like cow, Cow, CoW appears in the name-column.
-- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql