Re: GIN versus zero-key queries

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: GIN versus zero-key queries
Дата
Msg-id 1238100337.11547.79.camel@dell.linuxdev.us.dell.com
обсуждение исходный текст
Ответ на GIN versus zero-key queries  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, 2009-03-25 at 13:25 -0400, Tom Lane wrote:
> I am not sure whether the statement in 52.5 is still accurate, though.
> We have an API definition by which extractQuery can distinguish "all
> match" from "no match".  If we just legislate that "some match" isn't
> a valid behavior for zero-key queries, then the code is correct and the
> documentation is wrong.  However, if the above quote is correct, then
> I think newScanKey() is buggy.

Legislating that "some match" is invalid for zero-key queries seems
reasonable to me.

If the operator class author wants it to throw an error for zero keys
(as the documentation says should happen), they can do that easily
enough without being forced. However, if the opclass author finds "all
match" to be useful behavior (which seems reasonable), I don't see a
reason to stop them.

Regards,Jeff Davis



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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: maintenance_work_mem and autovacuum
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: maintenance_work_mem and autovacuum