--
I'm looking to make a SQL based Domain type blacklist for those that
have managed to really piss me off.
I had a list in my Sendmail Access File, and would like to convert it
to a PostgreSQL DB with a table structure containing at least the following:
domain text,
message text
What I want to be able to do is match the sender (From: and envelope, and
the host names) and match even if the host part of the domain is different,
I.E:
domain='bad.domain.com'
I want to be able to match host222.bad.domain.com as well as just
bad.domain.com.
Anyone have any hints, suggestions examples, etc?
The partial- type queries look to be what I want, but they don't (based on
my read of the docs) work with SQL type queries.
Thanks!
LER
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@???
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
--
[ Content of type application/pgp-signature deleted ]
--
