Commit | Line | Data |
---|---|---|
59371ea7 PH |
1 | # pgsql lookups - expects specific data |
2 | exim -d-all+lookup -be | |
3 | ${lookup pgsql {select name from them where id='ph10';}} | |
4 | ${lookup pgsql {select name from them where id='ph10';}} | |
5 | ${lookup pgsql {select name from them where id='xxxx';}} | |
6 | ${lookup pgsql {select name from them where id='nothing';}} | |
7 | ${lookup pgsql {select id,name from them where id='nothing';}} | |
8 | ${lookup pgsql {delete from them where id='nonexist';}} | |
9 | ${lookup pgsql {select * from them where id='quote2';}} | |
10 | ${lookup pgsql {select * from them where id='newline';}} | |
11 | ${lookup pgsql {select * from them where id='tab';}} | |
5547e2c5 | 12 | ${lookup pgsql {select * from them where name='${quote_pgsql:'stquot}';}} |
59371ea7 PH |
13 | **** |
14 | exim -d -bh 10.0.0.0 | |
15 | mail from:<a@b> | |
16 | rcpt to:<c@d> | |
17 | rcpt to:<c@d> | |
18 | quit | |
19 | **** | |
20 | exim -odi -d CALLER | |
21 | Test message | |
22 | . | |
23 | **** | |
24 | exim -DSERVERS=\(/tmp/.s.PGSQL.5432\)/test/ph10/ -d-all+lookup -be | |
25 | ${lookup pgsql {select name from them where id='CALLER';}} | |
26 | **** |