"Rajat Katyal" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
