Comments (3)
foxcpp
commented on May 29, 2024
Try
replace_rcpt sql_query {
import pg_con
lookup "SELECT address AS addresses FROM aliases WHERE alias = $1"
}
It is not necessary to use STRING_AGG, sql_query already handles multiple rows in query result as multiple values.
from maddy.
pkejval
commented on May 29, 2024
Yes, its working, thank you! Reason for opening this request was this sentence in documentation:
https://maddy.email/reference/table/sql_query/
lookup query
Required.
SQL query to use to obtain the lookup result.
It will get one named argument containing the lookup key. Use :key placeholder to access it in SQL.
The result row set should contain one row, one column with the string that will be used as a lookup result.
If there are more rows, they will be ignored. If there are more columns, lookup will fail.
If there are no rows, lookup returns "no results". If there are any error - lookup will fail.
hence I must admit I didn't try it without STRING_AGG() 😵💫
Sorry for bothering you with nonexistent issue!
from maddy.
foxcpp
commented on May 29, 2024
Woops, that's outdated and should be fixed.
from maddy.
Related Issues (20)
- POP3 support HOT 2
- Check the From header for inbound mail HOT 2
- Bug report: ssl cert expired for docs site HOT 6
- Strict CRLF check in SMTP protocol
- Unable to start Ubuntu 22.04.3 LTS aarch64 HOT 8
- [Feature request] auto configure DKIM key via libdns HOT 2
- Bug report: submission: listening on tls://0.0.0.0:465 not open HOT 1
- cannot specify tls_client directive HOT 4
- Feature request: additional infos in "queue: delivered" logging HOT 1
- Feature request System command filter. run_on header
- queue: infinite retries after reducing max_tries and bogus retry interval HOT 2
- cross compilation error : pq.Error does not implement error (method Error has pointer receiver) HOT 2
- Documentation for aliases
- Feature request: Make the DMARC check to be enforced regardless of DMARC record existence
- Specifying `tls_client` on `target.smtp` crashes at startup
- conn_max_idle_time ignored leading to remote: QUIT error
- does smtp send mail must be 25 port of targe host? HOT 3
- Website is down HOT 2
- SORT should return UIDs but returns none HOT 1
- outdated docs default tls version
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from maddy.