Re: Selecting all records which are in upper case

[Amitabh Kant <amitabhkant@xxxxxxxxx>]

On Sat, Aug 27, 2011 at 3:40 PM, Martijn van Oosterhout <kleptog@xxxxxxxxx> 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@xxxxxxxxx>   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