[GENERAL] Slow execution of the function due to the execution of dynamically generated queries defined inside it

2004-03-19 Thread Rajat Katyal
Hi:   I have a trigger function defined for the insert (pasted below) for the table say "transform_item_tgt" . The purpose of my trigger function is that before inserting each row it checks whether value in the primary key column exists or not. The checking is through executing the below men

[GENERAL] PERFORM statement inside procedure

2004-04-06 Thread Rajat Katyal
Hi:   In postgres documentation its written that if we execute query as PERFORM query inside our stored procedure; then the special variable FOUND is set to true if the query produced at least one row, or false if it produced no rows.   But FOUND variable is always returning true even my qu

Re: [GENERAL] PERFORM statement inside procedure

2004-04-07 Thread Rajat Katyal
- From: "Tom Lane" <[EMAIL PROTECTED]> To: "Rajat Katyal" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, April 07, 2004 11:15 AM Subject: Re: [GENERAL] PERFORM statement inside procedure > "Rajat Katyal" <[EMAIL