1 # pgsql lookups - expects specific data
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';}}
12 ${lookup pgsql {select * from them where name='${quote_pgsql:'stquot}';}}
24 exim -DSERVERS=\(/tmp/.s.PGSQL.5432\)/test/ph10/ -d-all+lookup -be
25 ${lookup pgsql {select name from them where id='CALLER';}}