Re: Enforcing Case

Or, if you want to make sure it is enforced by postgres, write a trigger
that'll use the upper() function to force the case after an insert.

> -----Original Message-----
> From: pgsql-novice-owner@postgresql.org
> [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of paul butler
> Sent: Thursday, August 22, 2002 11:48 AM
> To: JDK
> Cc: pgsql-novice@postgresql.org
> Subject: Re: [NOVICE] Enforcing Case
>
>
>
> >  have a small single table database that multiple people enter data
> > into, and I do some reporting from.  I would like to be able to force
> > everything to upper case because currently it seems that ABCD or abcd
> > or AbCd are all treated as unique, and it cause me problems in
> > reporting, not to mention it makes me nuts seeing the data in the
> > tables all inconsistent like that.
> >
> > How would I force everything to upper case?
>
> Would using the upper function work?
>
> for your data entry query
>
> insert into table (field) values (upper(value));
>
> It'll be ok for new entries, but you'll have to do some wrangling on
> the old ones if they are to remain unique.
>
> Or on the output side
>
> select upper(field)  from table
>
> Hope this helps
>
> Paul Butler
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>