From: | Larry Rosenman <ler(at)lerctr(dot)org> |
---|---|
To: | JDK <adahma(at)starport(dot)org> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Enforcing Case |
Date: | 2002-08-22 18:16:24 |
Message-ID: | 1030040184.824.8.camel@lerlaptop.iadfw.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Thu, 2002-08-22 at 13:08, JDK wrote:
> On Thu, Aug 22, 2002 at 04:47:53PM +0100, paul butler wrote:
> >
> > > 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));
> >
>
> OK, this worked nicely for my needs. Is there a command that I
> could run that would convert my existing data to all uppercase?
update table set field=upper(field);
>
> Thanks,
> jdk
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
From | Date | Subject | |
---|---|---|---|
Next Message | paul butler | 2002-08-23 06:21:01 | Re: changing the size of a column without losing data |
Previous Message | JDK | 2002-08-22 18:08:24 | Re: Enforcing Case |