Postgres Pro
Downloads
Home   >   mailing lists

how do I check for lower case - Mailing list pgsql-sql

From Juliann Meyer
Subject how do I check for lower case
Date
Msg-id 44DB97C5.9090307@noaa.gov
Whole thread Raw
Responses Re: how do I check for lower case  ("Rodrigo De León" <rdeleonp@gmail.com>)
Re: how do I check for lower case  (Daryl Richter <daryl@eddl.us>)
Re: how do I check for lower case  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: how do I check for lower case  (Oisin Glynn <me@oisinglynn.com>)
List pgsql-sql
Tree view 
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
Attachment

pgsql-sql by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Re: Change of data type
Next
From: "Rodrigo De León"
Date:
Subject: Re: how do I check for lower case