Re: how to test string against regular expression contained in postgresql - Mailing list pgsql-novice

hi,

Joe Bordes wrote:

> Hi All,
>
> 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.
>
> table
> os_regexp os_name
> ------------- -----------
> win.*9x windows
> linux linux
> etc...
>
> select os_name from table where 'windows9x' ~ os_regexp;
> ERROR: invalid regular expression: empty expression or subexpression.

create a function for that.

create or replace function osregexp(varchar,varchar) returns boolean as
' select $1 ~ $2; 'language sql immutable;

SELECT osregexp('windows9x','win.*9x');
  osregexp
----------
  t

C.