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 <postfix-us...@dukhovni.org> wrote: > 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 hard, Postfix automatically handles multiple > result rows, no need to do aggregation. > >> This returns a comma separated list of destinations. >> destination >> ----------------------------------------- >> tho...@example.com,oli...@example.com > > Test with "postmap -q ...". This should return multiple output lines > one per recipient. > >> May 24 10:01:03 helios postfix/pickup[25429]: D1DDF807AA: uid=0 from=<root> >> May 24 10:01:03 helios postfix/cleanup[25472]: warning: table >> "pgsql:/etc/postfix/pgsql/virtual_alias_maps.cf": empty lookup result for: >> "tho...@example.com" -- ignored > > Perhaps a side-effect of the aggregation returning an empty string rather > than 0 rows. > > For further help post the postgres table definition .cf file and the > output of postmap -f -q "h...@example.com" pgsql:/path/to/table.cf > > -- > Viktor.
