Re: Is there bigintarray?
| От | Jeff Janes |
|---|---|
| Тема | Re: Is there bigintarray? |
| Дата | |
| Msg-id | CAMkU=1zmxAQLPe9HHuCgddNyxGhBa_Gouny4anqmoaZ0npaKSg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Is there bigintarray? (Thomas Kellerer <spam_eater@gmx.net>) |
| Список | pgsql-general |
On Mon, Nov 2, 2015 at 1:41 PM, Thomas Kellerer <spam_eater@gmx.net> wrote: > Igor Bossenko schrieb am 02.11.2015 um 14:20: >> >> What is the current plans for bigintarray? >> >> Igor >> >> > > The following works for me: > > create table foo > ( > bia bigint[] > ); But you can't build indexes on them using the intarray extension opclasses, which I think is what he wants to know about. There is gist__intbig_ops, but that is for big arrays of ints, not for arrays of bigints. As far as I know there are no plans on this front. If Igor only needs &&, @> and <@ then he can just use the builtin gin opclass for those. But he can't get @@ and ~~ from the built-ins. Cheers, Jeff
В списке pgsql-general по дате отправления: