Re: INSERT Trigger to check for existing records

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Hagen Finley <hagen(at)datasundae(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: INSERT Trigger to check for existing records
Date: 2020-11-21 18:17:57
Message-ID: CAKFQuwZQXdHJ=Maf6FgSnP3SZdn9jQtLb7qXR6_vrzioJXbnRg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Saturday, November 21, 2020, Hagen Finley <hagen(at)datasundae(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2020-11-21 18:24:34 Re: INSERT Trigger to check for existing records
Previous Message Adrian Klaver 2020-11-21 17:59:32 Re: INSERT Trigger to check for existing records