Thanks for your remark. I gave it a try on postgresql 11.5. Running different
versions of my query against it gives the same result for my case:
SELECT CONCAT(username, '@', domain) FROM users WHERE ?1 LIKE mailbox;
SELECT CONCAT(username, '@', domain) FROM users WHERE mailbox LIKE ?1;
I'm still
Hi misc@
I have an issue finding the correct syntax in smtp.conf.
Sympa Docs say the following
table sympa db:$SYSCONFIDR/sympa_domain_aliases.db
accept from any for any recipient virtual
table lists db:$SENDMAIL_ALIASES.db
accept from any for any recipient virtual
#
# Here may b
I just tested with MySQL and the result is the same.
smtpd -dv -T lookup yielded:
de334c3363d95880 smtp authentication user=u...@host.com result=ok
debug: smtp: SIZE in MAIL FROM command
debug: lka: mailaddrmap senderalias:u...@host.com
lookup: lookup "u...@host.com" as MAILADDRMAP in table proc
Hello Giovanni,
I just gave it a try. The order of the operands of the LIKE operator doesn't
make any difference. I just tested it manually against my sqlite database. The
returned results are identical.
Greetings,
Michael
‐‐‐ Original Message ‐‐‐
Am Montag, Oktober 14, 2019 9:15 AM
On 10/12/19 4:46 PM, y38...@protonmail.com wrote:
> SELECT (username||'@'||domain) FROM users WHERE ? LIKE mailbox
I think it should read
SELECT (username||'@'||domain) FROM users WHERE mailbox LIKE ?
typo or error ?
Giovanni