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

Поиск
Список
Период
Сортировка
От Pól Ua Laoínecháin
Тема Re: Want records to be UNIQUE. When searching for dupes, stop onfirst matching record.
Дата
Msg-id CAF4RT5TVGHDTb-TQCgr+f-8PuPcH+efNyTy2wva6GOL6WSNbrQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Want records to be UNIQUE. When searching for dupes, stop onfirst matching record.  (Peter Geoghegan <pg@bowt.ie>)
Ответы SELECTing for group membership of many groups?  (Pól Ua Laoínecháin <linehanp@tcd.ie>)
Список 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...

В списке pgsql-novice по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Want records to be UNIQUE. When searching for dupes, stop onfirst matching record.
Следующее
От: Pól Ua Laoínecháin
Дата:
Сообщение: SELECTing for group membership of many groups?