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
ray@???
--
## subscription configuration (requires account):
##
https://lists.exim.org/mailman3/postorius/lists/exim-users.lists.exim.org/
## unsubscribe (doesn't require an account):
## exim-users-unsubscribe@???
## Exim details at
http://www.exim.org/
## Please use the Wiki with this list -
http://wiki.exim.org/
