Skip site navigation (1) Skip section navigation (2)

Re: Enforcing Case

From: JDK <adahma(at)starport(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Enforcing Case
Date: 2002-08-22 18:08:24
Message-ID: 20020822180824.GC26075@starport.org (view raw or flat)
Thread:
Lists: pgsql-novice
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?

Thanks,
jdk


In response to

Responses

pgsql-novice by date

Next:From: Larry RosenmanDate: 2002-08-22 18:16:24
Subject: Re: Enforcing Case
Previous:From: Mark SeftelDate: 2002-08-22 17:43:57
Subject: changing the size of a column without losing data

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group