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 Rosenman||Date: 2002-08-22 18:16:24|
|Subject: Re: Enforcing Case|
|Previous:||From: Mark Seftel||Date: 2002-08-22 17:43:57|
|Subject: changing the size of a column without losing data|