String in Postgres; validation of the contents of a string

Question

I would like a way to validate a string, it needs to have only letters and uppercase; but I could not find a way to do that.

Alan Kavanagh · Accepted Answer · 2017-09-27 14:59:19Z

2

Check for all records where the value 'record' matches only upper or lowercase letters from a-z

SELECT value FROM values WHERE value ~ '[A-Za-z]';

answered Sep 27, 2017 at 14:59

Alan Kavanagh

9,9338 gold badges46 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Perfect, this solves my problem, but I need it to be just the lyrics; special characters like 'ÉÈÇÊ' and so on can not be in my string

does [a-zA-Z] return values containing 'ÉÈÇÊ' ?

shall not contain such characters; once inside the string has one of these; I need a false return.

Only accept the space character and the following characters in parentheses: (ABCDEFGHIJKLMNOPQRSTUVWXYZ 0123456789 ª º - /.,).