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: (view raw, whole thread or download thread mbox)
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  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-2017 The PostgreSQL Global Development Group