Re: [GENERAL] using gist index with dual-temporal timestamp values

2010-03-31 Thread Andreas Kretschmer
Anssi Kääriäinen wrote: > > So, the question is: Is there any (relatively easy) way to use gist > index with dual-temporal tables? I think this will be asked a lot > when 9.0 with exclusion constraints is released. The feature seems > really powerful, but unfortunately supporting data types seem

[GENERAL] using gist index with dual-temporal timestamp values

2010-03-31 Thread Anssi Kääriäinen
Hello list, My problem is that I would like to use the gist index with box datatype for dual-temporal valid_from values. Querying dual-dimensional tables using boxes is much easier to write, and hopefully the query will also run more efficiently, than when using the standard approach of direct co