On Mon, Sep 13, 2010 at 07:23:41PM +0200, Valentin Gjorgjioski wrote:
> Have tried this
> SELECT destination FROM view_aliases WHERE '%s' like
> concat('%%',email,'%%') and '%...@%d' not in (select email from view_users);
Postmap does a single lookup with the literal key you supply. Virtual
alias lookups on the other hand, use multiple lookup keys and are
recursive. You need to test all the lookup keys, and recursively test
any output values.
> query = SELECT destination FROM view_aliases WHERE email='%s'
>
> was working just fine so far.
It would be a good idea to stick to that.
--
Viktor.
