Re: force varchar column to be lowercase

From: Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de>
To: Kevin Kempter <kevink(at)consistentstate(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: force varchar column to be lowercase
Date: 2009-07-28 10:15:03
Message-ID: 4A6ECFA7.30005@netzmeister-st-pauli.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Greg Stark 2009-07-28 10:50:28 Re: force varchar column to be lowercase
Previous Message Albert Shih 2009-07-28 07:46:31 WAL backup