-
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
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
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