> So I came up with this:
>
> query = select if ('%d' = 'example-2.com', IFNULL((select dest
> from aliases where addr = '%[email protected]'), (select addr from users
> where addr = '%[email protected]')), (select dest from aliases where addr =
> '%s'))
>
> This seems to work in all cases except when I send to
> "[email protected]" because I have an alias with just the local
> part:
>
> postmaster [email protected]
>
> This causes a bounce instead of reject.
Oops. I mean it causes a bounce (not instant reject) (bounce says
"[email protected] is invalid) instead of being delivered correctly
> Do I have to add a clause for this to my
> query? I start to feel like I'm doing things Postfix should be doing. There
> must be a more simple way to do this?