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" <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 по дате отправления
От: David Garamond
Дата:
От: Tom Lane
Дата:
FAQ