Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1NHxTx71990 for ; Fri, 23 Feb 2001 12:59:29 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from web10803.mail.yahoo.com (web10803.mail.yahoo.com [216.136.130.245]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1JKY3x90679 for ; Mon, 19 Feb 2001 15:34:03 -0500 (EST) (envelope-from jkypa@yahoo.com) Message-ID: <20010219203401.42587.qmail@web10803.mail.yahoo.com> Received: from [198.180.251.250] by web10803.mail.yahoo.com; Mon, 19 Feb 2001 12:34:01 PST Date: Mon, 19 Feb 2001 12:34:01 -0800 (PST) From: Jyotsna Kypa Subject: Need your help To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200102/362 X-Sequence-Number: 1561 Hi, I need your help on something. I have to write a trigger (in sybase) that does this: Everytime a record gets updated it should update a column in that record with the current date/time. I am able to do it for the whole table, but how do I make sure the update happens only for that record which is being updated? Please respond. Thanks a bunch, Jyotsna. __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/