Postgres Pro
Downloads
Home   >   mailing lists

Re: INSERT Trigger to check for existing records - Mailing list pgsql-general

From David G. Johnston
Subject Re: INSERT Trigger to check for existing records
Date
Msg-id CAKFQuwZK_igf_c2CuEUWC-VAYxHeR1+PAfTtATzTJZX5836wFA@mail.gmail.com
Whole thread Raw
In response to Re: INSERT Trigger to check for existing records  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses RE: INSERT Trigger to check for existing records  (<hagen@datasundae.com>)
List pgsql-general
Tree view
On Saturday, November 21, 2020, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Saturday, November 21, 2020, Hagen Finley <hagen@datasundae.com> wrote:

David,

That's an interesting idea. I WOULD like  to retain the OLD records that are the same and only INSERT new or changed records. Is there a way to compare the old and the new records without a trigger?


A where clause?


Did you get the part in the plan where there are two tables, existing and new? You write queries that join the two tables together and use the where clause in those queries to limit records.

David J.
 

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: INSERT Trigger to check for existing records
Next
From:
Date:
Subject: RE: INSERT Trigger to check for existing records