Message-ID: <44DBB80D.50707@oisinglynn.com>
Date: Thu, 10 Aug 2006 18:49:49 -0400
From: Oisin Glynn <me@oisinglynn.com>
Reply-To: me@oisinglynn.com
User-Agent: Thunderbird 1.5.0.5 (Windows/20060719)
MIME-Version: 1.0
To: Juliann Meyer <Julie.Meyer@noaa.gov>
CC: pgsql-sql@postgresql.org
Subject: Re: how do I check for lower case
References: <44DB97C5.9090307@noaa.gov>
In-Reply-To: <44DB97C5.9090307@noaa.gov>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Juliann Meyer wrote:
> I have a table with a column, lets call it identifier, that is defined 
> as varchar(8) that should never contain lower case letters.  Its a 
> large table.  Is there a way to query the table to see if any values 
> in this column are lower case and to get a list out?  The user 
> interface application that users use prevents them from adding an 
> entry in lower case  now, but didn't in earlier version.
> Julie
>
> ------------------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>   

Not sure if  this is over simple  and perhaps this would be a concern on 
a very large table but 

select * from table where identifier <> upper(identifier);

would give a list of all where the entry is not all uppercase?

Oisin