Re: [HACKERS] regression: select_views.sql

Thomas G. Lockhart wrote:
>
> >
> > vac=> select oprname, oprcode from pg_operator where oprcanhash and oprname <> '=';
> > oprname|oprcode
> > -------+------------
> > ~=     |intervalsame
> > ^^^^^^^^^^^^^^^^^^^^ ok, but others are not!
> > <>     |intervalne
> > <      |intervallt
> > >      |intervalgt
> > <=     |intervalle
> > >=     |intervalge
> > (6 rows)
>
> Hmm. Those look like they support the "time interval" type, which I haven't been updating
> because it is based on abstime; I'm more interested in the wider-range/more-precise
> datetime-based stuff. I would think about rewriting the time interval routines, but
> assume it was used somewhere in the backend to support time travel. Don't know if it is
> still in there somewhere...

I just say that all these <>, <, >, >=, <= must have FALSE in oprcanhash.
Having TRUE for them is bug.

Vadim