Kevin Kempter schrieb:
Can I use a check constraint, or something other than a function to force a column to be lowercase only?Thx in advance
try to use regexp in your CHECK CONSTRAINT: CHECK (column::bpchar ~ '^[a-z]+$'::bpchar::text) Cheers Andy -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
