Rodrigo Sakai wrote: > Basically, the data type is a composition of two timestamps, like: > (timestamp, timestamp) and it is called 'period'. So, almost everything is > fine. Data type is ok, operators are ok, but the index doesn't work fine.
Does type tinterval not suit you? It is not very well documented but it should work, or at least serve as a basis for developing your own types. -- Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J Essentially, you're proposing Kevlar shoes as a solution for the problem that you want to walk around carrying a loaded gun aimed at your foot. (Tom Lane) ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
