Received: from lennon.postino.com (h24-78-217-170.vn.shawcable.net [24.78.217.170]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f741L6676967 for ; Fri, 3 Aug 2001 21:21:06 -0400 (EDT) (envelope-from danny@lennon.postino.com) Received: (from danny@localhost) by lennon.postino.com (8.11.0/8.11.0) id f740PCa26565; Fri, 3 Aug 2001 17:25:12 -0700 From: Danny Aldham Message-Id: <200108040025.f740PCa26565@lennon.postino.com> Subject: Re: Knowing new item in table... To: jdearl@yahoo.com (Jason Earl) Date: Fri, 3 Aug 2001 17:25:12 -0700 (PDT) Cc: pgsql-novice@postgresql.org In-Reply-To: <20010803174231.57921.qmail@web10006.mail.yahoo.com> from "Jason Earl" at Aug 03, 2001 10:42:31 AM X-Mailer: ELM [version 2.5 PL3] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200108/17 X-Sequence-Number: 1823 > > > --- macky wrote: > > im still in the dark when it comes to postgres..... > > is there a way i can > > know if there was a new entry on a table... > > That's a pretty common problem. > create trigger upd_table before insert table for each row execute -- Danny Aldham Providing Certified Internetworking Solutions to Business www.postino.com E-Mail, Web Servers, Web Databases, SQL PHP & Perl