Re: Re: Convert to upper - Mailing list pgsql-general

From Mitch Vincent
Subject Re: Re: Convert to upper
Date
Msg-id 014501c0a336$4d715b90$0200000a@windows
Whole thread Raw
In response to Convert to upper  (Matthias Teege <matthias@mteege.de>)
List pgsql-general
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
>


pgsql-general by date:

Previous
From: David Wheeler
Date:
Subject: Re: Perl & DBI/DBD::Pg confusion with finish
Next
From: "Trewern, Ben"
Date:
Subject: RE: Convert to upper