Re: [ADMIN] force varchar column to be lowercase

Greg Stark schrieb: On Tue, Jul 28, 2009 at 11:15 AM, Andreas Wenk wrote: 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

Re: [ADMIN] force varchar column to be lowercase

On Tue, Jul 28, 2009 at 11:15 AM, Andreas Wenk wrote: > 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

Re: [ADMIN] 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 -- Sent via pgsql-admin mailing list (p

[ADMIN] force varchar column to be lowercase

Can I use a check constraint, or something other than a function to force a column to be lowercase only? Thx in advance -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin