Re: Want records to be UNIQUE. When searching for dupes, stop on first matching record.

Pól Ua Laoínecháin <[email protected]> Mon, 22 Apr 2019 21:07:13 +0100

Newsgroups	gmane.comp.db.postgresql.novice
Message-ID	<CAF4RT5TVGHDTb-TQCgr+f-8PuPcH+efNyTy2wva6GOL6WSNbrQ@mail.gmail.com>

> It sounds like you're looking for a loose index scan:
> https://wiki.postgresql.org/wiki/Loose_indexscan

Hi and thanks for your input,

but I don't think that the loose index scan is what I want.

I want a query that breaks off immediately it finds a dupe and won't
continue any futher and that doesn't use LIMIT!

Maybe there's no such thing available - I'm just asking on the
offchance that it does exist.


Pól...