> On Oct 26, 2021, at 11:05 AM, Rich Shepard <rshepard(at)appl-ecosys(dot)com> wrote:
>
> On Tue, 26 Oct 2021, Rob Sargent wrote:
>
>> What do you get when you select * where person_nbr = 6 and contact_date =
>> ‘2021-10-26’ and contact_type = ‘Email’ from activities; ?
>
> Rob,
>
> <where person_nbr = 6 and contact_date = '2021-10-26' and contact_type = 'Email';
> person_nbr | contact_date | contact_type | notes | next_contact ------------+--------------+--------------+-------+--------------
> (0 rows)
>
> Rich
>
Are you doing a batch of updates, and including/generating a duplicate in there?
>