Re: Query planner question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ernest E Vogelsinger <ernest(at)vogelsinger(dot)at>
Cc: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Query planner question
Date: 2003-06-13 20:38:07
Message-ID: 3520.1055536687@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ernest E Vogelsinger <ernest(at)vogelsinger(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-06-13 20:40:07 Re: viewing the original order of entered records
Previous Message weigelt 2003-06-13 20:37:08 Re: using sequences