Re: PERFORM statement inside procedure
От
Tom Lane
Тема
Re: PERFORM statement inside procedure
Дата
Msg-id
5890.1081316725@sss.pgh.pa.us
Ответ на
Re: PERFORM statement inside procedure (Rajat Katyal)
Список
Дерево обсуждения
Re: PERFORM statement inside procedure "Rajat Katyal" <rajatk@intelesoftech.com>
Re: PERFORM statement inside procedure Tom Lane <tgl@sss.pgh.pa.us>
"Rajat Katyal" writes: > checkPKSql := ''select * from "transform_customer_billing" ''; > checkPKSql := checkPKSql || '' where "inv_no" = '' || quote_literal(new= > ."inv_no"); > PERFORM checkPKSql; You seem to be confusing PERFORM with EXECUTE. They are very different. The above PERFORM is really equivalent to SELECT 'select ...'; which naturally yields a row containing a not-very-useful string value. regards, tom lane
В списке pgsql-general по дате отправления