Re: Collation order for btree-indexable datatypes - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Collation order for btree-indexable datatypes
Date
Msg-id 200105022319.f42NJ4m24592@candle.pha.pa.us
Whole thread Raw
In response to Collation order for btree-indexable datatypes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Collation order for btree-indexable datatypes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> A closely related problem is that the "current time" special value
> supported by several of the date/time datatypes is inherently not
> compatible with being indexed, since its sort order relative to
> ordinary time values keeps changing.  We had discussed removing this
> special case, and I think agreed to do so, but it hasn't happened yet.
> 
> What I'm inclined to do is force consistency of the comparison operators
> now (for 7.1.1) and then remove "current time" for 7.2, but perhaps it'd
> be better to leave the whole can of worms alone until 7.2.  Comments
> anyone?

Comparing NaN/Invalid seems so off the beaten path that we would just
wait for 7.2.  That and no one has reported a problem with it so far.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: bruc@stone.congenomics.com (Robert E. Bruccoleri)
Date:
Subject: XFS File systems and PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: \c connects as another user instead I want in psql