Oh, I misunderstood.. I read his post that he wanted anything inserted to be
converted to upper case.. If you're just looking to throw an error if it's
not upper case, the check constraint is the way to go..
My apologies, I'll try and read more carefully..
-Mitch
----- Original Message -----
From: "Rod Taylor" <rod.taylor@inquent.com>
To: <pgsql-general@postgresql.org>
Sent: Friday, March 02, 2001 11:05 AM
Subject: Re: Re: Convert to upper
> check
>
> create table uppercase (
> name char(15) check (name ~ '[A-Z]')
> );
>
> --
> Rod Taylor
>
> There are always four sides to every story: your side, their side, the
> truth, and what really happened.
> ----- Original Message -----
> From: "Mitch Vincent" <mitch@venux.net>
> To: <pgsql-general@postgresql.org>
> Sent: Friday, March 02, 2001 10:52 AM
> Subject: [GENERAL] Re: Convert to upper
>
>
> > > 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
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>