pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSTORAGE and GiST
2+ messages / 2 participants
[nested] [flat]
* STORAGE and GiST
@ 2003-02-25 14:06 Itai Zukerman <zukerman@math-hat.com>
0 siblings, 1 reply; 2+ messages in thread
From: Itai Zukerman @ 2003-02-25 14:06 UTC (permalink / raw)
To: pgsql-sql
Does anyone know of any examples of using STORAGE with GiST? I can't
seem to find any docs that explain how it's supposed to work, beyond
that it somehow involves the compress function. All the examples I've
seen have the key using the same type as the value being indexed...
Scenario: I'm doing a simplified re-write of intarray with intbig ops,
where I define a new fixed-length type (4k bit vector) for the GiST
keys.
--
Itai Zukerman <http://www.math-hat.com/~zukerman/;
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: STORAGE and GiST
@ 2003-02-25 15:32 Tom Lane <tgl@sss.pgh.pa.us>
parent: Itai Zukerman <zukerman@math-hat.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2003-02-25 15:32 UTC (permalink / raw)
To: Itai Zukerman <zukerman@math-hat.com>; +Cc: pgsql-sql
Itai Zukerman <zukerman@math-hat.com> writes:
> Does anyone know of any examples of using STORAGE with GiST?
[ greps... ] contrib/btree_gist, contrib/rtree_gist, contrib/ltree,
contrib/tsearch all seem to use that option. I believe the point
is to store a different datatype in the index than is used in the
column being indexed.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-02-25 15:32 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-25 14:06 STORAGE and GiST Itai Zukerman <zukerman@math-hat.com>
2003-02-25 15:32 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox