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