求助！postgresql 动态sql执行问题报错！

cike5

写了个存储过程。里面嵌入了这么条语句。
execute 'select count(*) from  temp_crm_info_t where searchengine_id = $1' into count
    using in_searchengine_id;
    return count;
-------------------------------------------------------编译的时候报错
ERROR:  syntax error at or near "using"
LINE 21:     using in_searchengine_id;
             ^

********** 错误 **********

ERROR: syntax error at or near "using"
SQL 状态: 42601
字符:1415
---------------------------------------------但是我查参考手册postgresql-9.2-A4.pdf
里面是有类似写法的。
EXECUTE ’SELECT count(*) FROM ’
|| tabname::regclass
|| ’ WHERE inserted_by = $1 AND inserted <= $2’
INTO c
USING checked_user, checked_date;
---------------------------------------------请懂行的帮忙指点一下，谢谢

osdba

osdba=# CREATE FUNCTION myfunc() RETURNS integer AS $$
osdba$# DECLARE
osdba$#     in_searchengine_id integer;
osdba$#     count integer;
osdba$# BEGIN
osdba$#     in_searchengine_id :=10;
osdba$#     execute 'select count(*) from  temp_crm_info_t where searchengine_id = $1' into count
osdba$#     using in_searchengine_id;
osdba$#     return count;   
osdba$# END;
osdba$# $$ LANGUAGE plpgsql;
CREATE FUNCTION

没有错误啊？ 你是否是在"using"前输入了中文啊？

yueliangdao0608

lS正解。