note
1nickt
<P>
Hi again, maybe what you need is an no-op "upsert", implemented in Postgres with <c>INSERT ON CONFLICT</c> ?
</P>
<P>
Something like
<c>
INSERT INTO myTable (foo, bar)
VALUES ('baz', 'qux')
ON CONFLICT (foo)
DO NOTHING;
</c>
... where <c>foo</c> is your column that has a unique key constraint.
</P>
<P>
Hope this helps!
</P><BR>
<div class="pmsig"><div class="pmsig-1130276">
<i>The way forward always starts with a minimal test.</i>
</div></div>
11115368
11115494