Horton

Re: Convert to upper

Mitch Vincent <mitch@venux.net>

View thread View on postgr.es
From: "Mitch Vincent" <mitch@venux.net>
To: <pgsql-general@postgresql.org>
Date: 2001-03-02T15:52:36Z
Lists: pgsql-general 
> is there any way to limit values to upper case strings?
> Somthing like:
> 
> name char(15) DEFAULT (upper(name))
>
> or must I use triggers?

I'd say a trigger is your best bet. 

-Mitch