Re: Query planner question - Mailing list pgsql-general

From Tom Lane
Subject Re: Query planner question
Date
Msg-id 3520.1055536687@sss.pgh.pa.us
Whole thread Raw
In response to Re: Query planner question  (Ernest E Vogelsinger <ernest@vogelsinger.at>)
List pgsql-general
Ernest E Vogelsinger <ernest@vogelsinger.at> writes:
> So if I get you right the "IS NULL" predicate doesn't fit into "<op>"
> "<value>"?

Exactly.

In the last go-round on this topic, there was some discussion of
changing IS NULL from a specialized construct into an operator
(and underlying function), which'd allow it to be fit into the
index opclass abstraction.  I think it's doable, but no one's
got round to doing it yet.

            regards, tom lane

pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: return records in DB load order??
Next
From: "scott.marlowe"
Date:
Subject: Re: Pg_dumpall