Re: Concatenating a domain to a map result

[Duane Hill]

On Mon, 4 Aug 2008, Jay Chandler wrote:

I'm attempting to map local_recipient_maps via a Pgsql query.

The database contains the username portion of [EMAIL PROTECTED]

Is there a way to append @example.com to the result of the lookup query?

I'm not familiar with Pgsql. However, MySQL has a concatenate:

  SELECT CONCAT(username, '@example.com') from usernames;

-d