Unanswered: how to test string against regular expression contained in postgresql database field
I have a table which contains a field with regular expressions. I want to test a given string against this field to obtain the resulting records but I am doing something wrong and cannot find out what.
select os_name from table where 'windows9x' ~ os_regexp;
ERROR: invalid regular expression: empty expression or subexpression.