Re: pgsql 'prefix' error

Поиск
Список
Период
Сортировка
От Harald Fuchs
Тема Re: pgsql 'prefix' error
Дата
Msg-id pubpiqfq2h.fsf@srv.protecting.net
обсуждение исходный текст
Ответ на How is the right query for this condition ?  (Bino Oetomo <bino@indoakses-online.com>)
Список pgsql-general
In article <87tywid19x.fsf@hi-media-techno.com>,
Dimitri Fontaine <dfontaine@hi-media.com> writes:

> The BTree opclass is not made to resist to overlapping data. Maybe in
> this case though we could say that 12 contains less elements than 1 so
> it's less than 1. Here's a test to redefine the pr_cmp() operator in
> term of that, as a patch against current CVS (which is 1.0.0).

> Can you test with this version and maybe better data set?

Looks good.

> Note that as said earlier the indexing you need to speed up queries is
> the GiST one, but it could be you want the PK constraint noneless.

Indeed - I think it's a good thing to be able to prevent something
like

  INSERT INTO myrecords (record) VALUES ('12'), ('12');

Oh, here's another gripe: how about renaming README.txt to README.prefix
and removing TESTS.* from "make install"?

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: [BUGS] Re: How duplicate data produce when a UNIQUE index exite ?
Следующее
От: "Gauthier, Dave"
Дата:
Сообщение: limiting resources to users