Re: [Gusdev-gusdev] sres.externaldatabase lowecase_name?

[Hongxian He <hon...@pc...>]

Even at CBIL, lower() does not seem to do the trick for all (although i 
wonder if there are typos in some entries... and now all lowercase_names 
are in lower case...)


SQL> select count(*) from sres.externaldatabase where lower(name) != 
lowercase_name;

  COUNT(*)
----------
         8

SQL> select name, lowercase_name from sres.externaldatabase where 
lower(name) != lowercase_name;

NAME
--------------------------------------------------------------------------------
LOWERCASE_NAME
--------------------------------------------------------------------------------
Mouse Ensembl Peptides
mouse ensemble peptides

Mosquito Ensembl Peptides
mosquito ensemble peptides

Methanococcus jannaschii DSM2661 orfs
Methanococcus jannaschii DSM2661 orfs

HqPromoterAnalysis
hq_analysis

EPD Matrices
epd_matrices

Mouse Ensembl Peptides
mouse ensemble peptides

Scripps/GNF malaria array (scrmalaria)
affymetrix_gnf_malariachip

T1DBase
T1DBase


8 rows selected.


Hongxian

Ed Robinson wrote:

>We use the lowercase name as a place to store the database
>names we find in NRDB. e.g. (pir).  I don't know if this is
>appropriate or not, but it is an important field for how we
>deal with NRDB.
>
>-ed
>
>
>---- Original message ----
>  
>
>>Date: Thu, 24 Mar 2005 13:32:06 -0500
>>From: Michael Saffitz <msa...@pc...>  
>>Subject: [Gusdev-gusdev] sres.externaldatabase lowecase_name?  
>>To: "cbil >> 'cbil'" <cb...@pc...>, gusdev-gusdev
>>    
>>
><gus...@li...>
>  
>
>>Does anyone know why we have lowercase_name as a field in 
>>sres.externaldatabase?  Anyone using this?
>>
>>I'd like to remove it in GUS 3.5.  If you need to get the
>>    
>>
>lowercase 
>  
>
>>name, do:
>>
>>select lower(name) from sres.externaldatabase...
>>
>>Any objections?
>>
>>--Mike
>>
>>
>>-------------------------------------------------------
>>SF email is sponsored by - The IT Product Guide
>>Read honest & candid reviews on hundreds of IT Products from
>>    
>>
>real users.
>  
>
>>Discover which products truly live up to the hype. Start
>>    
>>
>reading now.
>  
>
>>http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>>_______________________________________________
>>Gusdev-gusdev mailing list
>>Gus...@li...
>>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>    
>>
>-----------------
>Ed Robinson
>Center for Tropical and Emerging Global Diseases
>University of Georgia, Athens, GA 30602
>ero...@ug.../(706)542.1447/254.8883
>  
>


-- 
---------------------------------------------
HONGXIAN HE, Post-doctoral Researcher
1423 Blockley Hall, Center for Bioinformatics
423 Guardian Dr., University of Pennsylvania
Philadelphia, PA 19104
Phone: 215-746-7016 | FAX: 215-573-3111
---------------------------------------------