OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Concatenating a domain to a map result

From: Duane Hill (d.hillyournetplus.com)
Date: Mon Aug 04 2008 - 14:22:24 CDT

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 usernameexample.com.
>
> 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