Обсуждение: test against regexp in database
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@home.de .* you@aol.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? -- PGP/GPG Key-ID: http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1
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@home.de .* >you@aol.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