> On Oct 26, 2021, at 11:05 AM, Rich Shepard <rshepard@xxxxxxxxxxxxxxx> 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? >
