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

From: Pól Ua Laoínecháin <linehanp(at)tcd(dot)ie>
To: Peter Geoghegan <pg(at)bowt(dot)ie>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Want records to be UNIQUE. When searching for dupes, stop on first matching record.
Date: 2019-04-22 20:07:13
Message-ID: CAF4RT5TVGHDTb-TQCgr+f-8PuPcH+efNyTy2wva6GOL6WSNbrQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> 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...

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Pól Ua Laoínecháin 2019-04-23 16:13:30 SELECTing for group membership of many groups?
Previous Message Peter Geoghegan 2019-04-18 22:37:25 Re: Want records to be UNIQUE. When searching for dupes, stop on first matching record.