在pgadmin3中,我希望使用参数化查询(为了更快地调试,只需从我的php文件中复制并粘贴查询).但我还没有找到一个选项来添加$1
$2
...参数.可能吗?
这是我在循环中构建的查询,遵循从here开始进行空测试的建议:
SELECT EXISTS(SELECT 1
FROM tax
WHERE (addby=$1 or addby<>$1)
AND (adddate=$2 or adddate<>$2)
AND ($3 IS NULL AND nome IS NULL OR nome=$3)
AND ($4 IS NULL AND rank IS NULL OR rank=$4)
AND ($5 IS NULL AND pai IS NULL OR pai=$5)
AND ($6 IS NULL AND valido IS NULL OR valido=$6)
AND ($7 IS NULL AND sinonvalid IS NULL OR sinonvalid=$7)
AND ($8 IS NULL AND espec IS NULL OR espec=$8)
AND ($9 IS NULL AND public IS NULL OR public=$9)
);
请注意,手动替换所有参数非常繁琐,容易出错,而且可能(我希望)没有必要.
提前谢谢.