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 CAKFQuwZQXdHJ=Maf6FgSnP3SZdn9jQtLb7qXR6_vrzioJXbnRg@mail.gmail.com
Whole thread Raw
In response to Re: INSERT Trigger to check for existing records  (Hagen Finley <hagen@datasundae.com>)
Responses Re: INSERT Trigger to check for existing records
List pgsql-general
Tree view
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?

David J. 

pgsql-general by date:

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