On Wed, Oct 21, 2009 at 10:34:19PM +0200, Magnus B?ck wrote: > SELECT address, '%...@sms.example.com' FROM table WHERE column = '%s' >
Note, this pulls '%u' from the localpart of the lookup address (%s). If the lookup result does not always have the same localpart, and you want the localpart of the result, not the input, you could try: result_format = %s, %...@sms.example.com which gets %u from the lookup result (at least with LDAP tables, and I think *SQL also, but I've not looked at the code for MySQL and PgSQL for a while). -- Viktor. Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the "Reply-To" header. To unsubscribe from the postfix-users list, visit http://www.postfix.org/lists.html or click the link below: <mailto:majord...@postfix.org?body=unsubscribe%20postfix-users> If my response solves your problem, the best way to thank me is to not send an "it worked, thanks" follow-up. If you must respond, please put "It worked, thanks" in the "Subject" so I can delete these quickly.