bind变量


EXECUTE format('UPDATE tbl SET %I = $1 WHERE key = $2', colname) USING newvalue, keyvalue;


 

posted @ 2014-05-30 10:34  bielidefeng  阅读(94)  评论(0编辑  收藏  举报