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 PROTECTED] writes: checkPKSql := ''select * from transform_customer_billing

[GENERAL] PERFORM statement inside procedure

2004-04-06 Thread Rajat Katyal
Hi: In postgres documentation its written that if we executequery 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. ButFOUND variable is always returning true even my query

[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 beforeinserting each row it checks whether value in the primary key column exists or not. The checkingis through executing the below