How to select records from a table in the uppercase in postgres?

0

I need to select all the records in a table where the letters of a particular column are in the uppercase (upper case). Is there a function that differentiates between uppercase and lowercase in POSTGRES ? Here is the image of my table:

The numero_fci column has several records as alphanumeric characters, however, some records are in lowercase (lowercase) and SELECT I would like to return only those that are in the uppercase. How should I proceed?
Thank you!

    
asked by anonymous 25.05.2017 / 21:13

1 answer

0

Selects all records that are different when you play them in a lower function. Example:

SELECT * FROM tabela WHERE LOWER(numero_fci) != numero_fci
    
25.05.2017 / 21:47