pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Danny Aldham <danny@lennon.postino.com>
To: jdearl@yahoo.com
Cc: pgsql-novice@postgresql.org
Subject: Re: Knowing new item in table...
Date: Fri, 3 Aug 2001 17:25:12 -0700 (PDT)
Message-ID: <200108040025.f740PCa26565@lennon.postino.com> (raw)
In-Reply-To: <20010803174231.57921.qmail@web10006.mail.yahoo.com>

> 
> 
> --- macky <macky@edsamail.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



view thread (8+ messages)

Message-ID: <200108040025.f740PCa26565@lennon.postino.com>
Permalink:  ../200108040025.f740PCa26565@lennon.postino.com/
Also on:    postgresql.org/message-id/200108040025.f740PCa26565@lennon.postino.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: danny@lennon.postino.com, jdearl@yahoo.com, pgsql-novice@postgresql.org
  Subject: Re: Knowing new item in table...
  In-Reply-To: <200108040025.f740PCa26565@lennon.postino.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox