[Dovecot] Recipient delimiters, deliver and SQL databases

Marshal Newrock marshal at idealso.com
Mon Dec 11 23:28:55 UTC 2006

On Tue, 12 Dec 2006 00:19:12 +0100
Nils Vogels <nivo+sender+9bb457 at is-root.com> wrote:

> On a side note: the SQL query from Marshal only works if there is a
> recipient delimiter present, if it is not, it adds the domain name to
> the e-mail address being looked up, causing all kinds of other
> problems. I haven't found a SQL query to mimic the desired deliver
> behaviour in this case yet.

I'm not sure what your data looks like.  If you can give a couple of
samples (with delimiter and without, including what's in the database),
I can probably cook up a good query for you. It might require an IF().

Marshal Newrock, Ideal Solution LLC

More information about the dovecot mailing list