On 08/20/14 14:16, Martijn van Duren wrote: > >> query_alias select COALESCE(destination, REPLACE(maddr, '@', >> '_')), ? as maddr from mail_forwarding where source=maddr; > > And of course I was a bit too fast with this one (column aliases can't > be used in other columns), so if something should work it would be: > > query_alias SET @maddr = ?; SELECT COALESCE(destination, > REPLACE(@maddr, '@', '_')) from mail_forwarding where source=@maddr; > > I've tested this one as a proof of concept, yet not in an > table_mysql.conf setup. > > I am curious if this works, so keep me posted. :) > nope, syntax error in query alias, anyway in my alias table I haven't all users, just real aliases, so the query won't match. Thanks & Cheers Giovanni
-- You received this mail because you are subscribed to [email protected] To unsubscribe, send a mail to: [email protected]
