Re: test against regexp in database

At 07:23 AM 11/24/02, Holger Marzen wrote:
>Hi boys and girls,
>
>as we all know, PostgreSQL can do selects on regexps. But I'd like to
>store regexps in a table with the columns "from" and "to". The "from"
>column should contain email sender adresses, and the "to" column should
>contain faxnumbers the user is allowed to send faxes to (mail to fax
>gateway). I'd like to uses regexps as well in the "to" column, say
>
>from to
>------ ---------
>holger(at)home(dot)de .*
>you(at)aol(dot)com ^0123.*
>
>and test against this. Of yourse I can do a select with "from=userid"
>and then pipe the result through some commands that do the regexp check.
>but is there a more elegant way to do this, maybe in a single select?

Works for me:
where from = userid and fax ~ to;

Frank