Thread: Is there bigintarray?
Hello.
We have a good intarray contrib module which contains a lot of features: additional functions, operators with GIN support etc.
Are there plans for bigintarray?
We have a good intarray contrib module which contains a lot of features: additional functions, operators with GIN support etc.
Are there plans for bigintarray?
On Sat, 13 Sep 2008, Dmitry Koterov wrote: > Hello. > > We have a good intarray contrib module which contains a lot of features: > additional functions, operators with GIN support etc. > > Are there plans for bigintarray? contrib/intarray has GiST index, not GIN, which has basic support for bigint[]. We have item in our TODO list http://www.sai.msu.su/~megera/wiki/TODO GiSTarray - intarray for all built-in data types - 1 week Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83
What is the current plans for bigintarray? Igor
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[] );
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