Postgres Pro
Downloads
Home   >   mailing lists

Problem with GIST-index and timestamps - Mailing list pgsql-general

From Sebastian Böck
Subject Problem with GIST-index and timestamps
Date
Msg-id 4270ADF7.6070806@freenet.de
Whole thread Raw
Responses Re: Problem with GIST-index and timestamps  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-general
Tree view 
Hello,

i wanted to define and GIST-index on a table with a timestamp-column
containing 'infinity' values, and it throws the following error:

ERROR:  cannot subtract infinite timestamps

Is this a known limitation?
How can i avoid or circumvent this?

Thanks in advance

Sebastian

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Thanks for Rekall link!
Next
From: Typing80wpm@aol.com
Date:
Subject: Thanks for insights into internal design