Re: force varchar column to be lowercase

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