Postgres Pro
Downloads
Home   >   mailing lists

Re: Want records to be UNIQUE. When searching for dupes, stop onfirst matching record. - Mailing list pgsql-novice

From Pól Ua Laoínecháin
Subject Re: Want records to be UNIQUE. When searching for dupes, stop onfirst matching record.
Date
Msg-id CAF4RT5TVGHDTb-TQCgr+f-8PuPcH+efNyTy2wva6GOL6WSNbrQ@mail.gmail.com
Whole thread Raw
In response to Re: Want records to be UNIQUE. When searching for dupes, stop onfirst matching record.  (Peter Geoghegan <pg@bowt.ie>)
Responses SELECTing for group membership of many groups?
List pgsql-novice
Tree view 
> 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...

pgsql-novice by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Want records to be UNIQUE. When searching for dupes, stop onfirst matching record.
Next
From: Pól Ua Laoínecháin
Date:
Subject: SELECTing for group membership of many groups?