Skip site navigation (1) Skip section navigation (2)

Re: Knowing new item in table...

From: Danny Aldham <danny(at)lennon(dot)postino(dot)com>
To: jdearl(at)yahoo(dot)com (Jason Earl)
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Knowing new item in table...
Date: 2001-08-04 00:25:12
Message-ID: 200108040025.f740PCa26565@lennon.postino.com (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-sql
> 
> 
> --- macky <macky(at)edsamail(dot)com> 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

In response to

pgsql-novice by date

Next:From: Francisco ReyesDate: 2001-08-05 19:51:04
Subject: Indeces vs small tables
Previous:From: Jason EarlDate: 2001-08-03 17:42:31
Subject: Re: Knowing new item in table...

pgsql-sql by date

Next:From: Allan EngelhardtDate: 2001-08-05 11:04:21
Subject: Using functions in SQL statements
Previous:From: Calvin DodgeDate: 2001-08-04 00:06:31
Subject: Re: Where is the database located in 7.1.2?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group