On 25/06/2023 03:39, Jasen Betts via Exim-users wrote:
<snip>
or possibly this (which returns a single row with colons between names)
MAIN_LOCAL_DOMAINS=${lookup pgsql{select string_agg(domain_name,':') from
domains }}
Thanks very much to everyone who replied - I went with this solution in
the end, and it works nicely. The issue was indeed that the query had to
return a string with colon-delimited items, so this does the trick.
This raises a related question - how often will this query get executed?
Is it once when the server is restarted, or each time a new client
connection begins, or something else altogether?
Many thanks,
Ray.
--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie
--
## subscription configuration (requires account):
## https://lists.exim.org/mailman3/postorius/lists/exim-users.lists.exim.org/
## unsubscribe (doesn't require an account):
## exim-users-unsubscr...@lists.exim.org
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
