| 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:24:34 |
| Message-ID: | CAKFQuwZK_igf_c2CuEUWC-VAYxHeR1+PAfTtATzTJZX5836wFA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Saturday, November 21, 2020, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> 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?
>
>
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hagen | 2020-11-21 18:49:06 | RE: INSERT Trigger to check for existing records |
| Previous Message | David G. Johnston | 2020-11-21 18:17:57 | Re: INSERT Trigger to check for existing records |