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

CoL <col@mportal.hu> wrote in message news:<c3s060$1k0m$1@news.hub.org>...
>
> 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.

Hi,

First thanks for answering.

This gives me the same error. I have created the function as you say
and it works when called directly with strings (as above) but not when
called with a table field.

select os_name from table where osregexp('windows9x',os_regexp);
ERROR: invalid regular expression: empty expression or subexpression

I even tried createing the function with STABLE and VOLATILE but I get
the same error

Joe.