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: (view raw, whole thread or download thread mbox)
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?


In response to


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-2017 The PostgreSQL Global Development Group