Re: [GENERAL] Selecting all records which are in upper case

2011-08-27 Thread Amitabh Kant
On Sat, Aug 27, 2011 at 3:40 PM, Martijn van Oosterhout 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 wh

Re: [GENERAL] Selecting all records which are in upper case

2011-08-27 Thread Martijn van Oosterhout
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 dat

[GENERAL] Selecting all records which are in upper case

2011-08-27 Thread Amitabh Kant
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: idname 1abcc 2Abc dsase 3CDF FDER 4A