Re: Need a nudge in the right direction (trivial-rewrite/cleanup)

2013-05-24 Thread Thomas Polliard
VIKTOR! You are the best Thank you SOO much, I seemed to miss the part of the doc that stated it could handle multiple rows! Thank you, thank you, thank you! Thomas On May 24, 2013, at 4:57 PM, Viktor Dukhovni wrote: > On Fri, May 24, 2013 at 04:37:25PM -0400, Thomas Polliard w

Re: Need a nudge in the right direction (trivial-rewrite/cleanup)

2013-05-24 Thread Viktor Dukhovni
On Fri, May 24, 2013 at 04:37:25PM -0400, Thomas Polliard wrote: > select array_to_string(array_agg(destination),',') > from postfix.alias_destination > where alias = (select alias_id >from postfix.alias_map >where alias = 'h...@example.com'); You're working too ha

Need a nudge in the right direction (trivial-rewrite/cleanup)

2013-05-24 Thread Thomas Polliard
Good Day all, I am trying to get the virtual_alias_map working with my setup. I have an address h...@example.com that will go to two other address, because after all the wife has to know everything I know ;). My pgsql query line is: select array_to_string(array_agg(destination),',') from