Hello, I have some problems using character class matching (e.g. [:alpha:]).
For example I have a table:
CREATE TABLE re_test (text_column character varying (50) NOT NULL);
Notice, that there is some specific characters.
INSERT INTO re_test VALUES ('AŠDF'); INSERT INTO re_test VALUES ('AŠDF45'); INSERT INTO re_test VALUES ('AŠDF FDŠA'); INSERT INTO re_test VALUES ('ASDF FDŠA'); INSERT INTO re_test VALUES ('58ASDF FDŠA'); INSERT INTO re_test VALUES ('ašDf'); INSERT INTO re_test VALUES ('aŠdf');
SELECT * FROM re_test WHERE text_column ~ '[^[:alpha:]]' and text_column ~ [:upper:];
Goal: I want to write such statement which returns me only those records which have only one word and those words must be uppercase. So I expect this statemet to return only one record where text_column = AŠDF.
Maybe someone could give me more detail explanation how to use those regexp classes, because the documentation tells very little about this.