X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0DED14758C9 for ; Tue, 18 Feb 2003 15:21:44 -0500 (EST) Received: from web20802.mail.yahoo.com (web20802.mail.yahoo.com [216.136.226.191]) by postgresql.org (Postfix) with SMTP id 576B1475843 for ; Tue, 18 Feb 2003 15:21:43 -0500 (EST) Message-ID: <20030218202144.42701.qmail@web20802.mail.yahoo.com> Received: from [208.13.35.65] by web20802.mail.yahoo.com via HTTP; Tue, 18 Feb 2003 12:21:44 PST Date: Tue, 18 Feb 2003 12:21:44 -0800 (PST) From: Jeff Eckermann Subject: Re: trigger after with cursor To: betty , pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/414 X-Sequence-Number: 11812 --- betty wrote: > I mean are there any solution for Using "Update" > statement > inside 'trigger after update'..??? for update it's > table self. > rather than using "CURSOR" > No. The only values you can change are those in the NEW row, by assigning values to them in your procedure. I could not tell from your code just what you are trying to do: if you could tell us more about that, perhaps someone can advise you. __________________________________________________ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com