Re: Selecting all records which are in upper case

On Sat, Aug 27, 2011 at 3:40 PM, Martijn van Oosterhout
<kleptog(at)svana(dot)org>wrote:

> On Sat, Aug 27, 2011 at 03:12:44PM +0530, Amitabh Kant wrote:
> > Hello
> >
> > I have a simple table 'location' :
> > id -> Int (associated with a sequence)
> > name -> Character varying (100)
> >
> > I have to delete all records where values in name field are all in upper
> > case. For example, if the test data is as follows:
>
> Might not work if you have non-ascii characters (but your example code
> breaks there too), but what about:
>
> DELETE ... WHERE upper(name) = name;
>
> Have a nice day,
> --
> Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
>

Thanks Martin. Definitely a much simpler way. I also cross-checked it on my
table, and it does work on non-ascii characters. It is only returning me
upper case entries. All other entries remain unaffected.

Amitabh