Hello, I'm trying to simplify a schema, where I had many ranges floating around. My idea is to put them all in an array field and query like this:
SELECT event.* FROM event JOIN participant_details USING (participant_id) WHERE tsrange(event.start, event.end) && ANY (participant_details.periods); periods is tsrange[]. I've tryed and it worked, but without indexes. I've tried something, but didn't found anything... Does someone know how to index this kind of field (tsrange[])? >From the docs I learn that there is some GIST magic, but I would need to code in C. Is that true? Regards, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル
