Mailing List Archive

table domains
Can be we shall add the table domains and clientid we shall use for
identification of an accessory of a box to the domain or we shall add in
users a field domain_idnr.
It will be more convenient to select users for domains, without special
researches on sql.
As it is more convenient for connection to anothers MTA, for example for
definition of the list of domains for relay.

For example on ORACLE at now:
select substr(userid,instr(userid,'@')+1)
from users
where userid not like '%internal_delivery_user%'

or

select userid
from users
where
substr(userid,instr(userid,'@')+1) = '%s'

Agree not so conveniently :)