Bruno Wolff III <[EMAIL PROTECTED]> writes:
> I went back and reread the stuff on NEGATOR and found it only applies
> to operators that return boolean types. I had thought it was different
> and would let you make the deduction a > b <=> -a <= -b, but that isn't
> the case. Instead it lets you make
On Fri, May 30, 2003 at 11:31:23 -0700,
Stephan Szabo <[EMAIL PROTECTED]> wrote:
> On Fri, 30 May 2003, Bruno Wolff III wrote:
>
> > I was hoping the new stuff Tom added would make doing this easier. The issue
> > has come up before and at least at that time it didn't get changed so I
> > expect
On Fri, 30 May 2003, Bruno Wolff III wrote:
> On Fri, May 30, 2003 at 10:42:24 -0700,
> Stephan Szabo <[EMAIL PROTECTED]> wrote:
> > On Fri, 30 May 2003, Bruno Wolff III wrote:
> >
> > > Now that expressions can be used in indexes in 7.4 you can have multicolumn
> > > indexes that are ordered in
On Fri, May 30, 2003 at 10:42:24 -0700,
Stephan Szabo <[EMAIL PROTECTED]> wrote:
> On Fri, 30 May 2003, Bruno Wolff III wrote:
>
> > Now that expressions can be used in indexes in 7.4 you can have multicolumn
> > indexes that are ordered in different directions. However the planner
> > doesn't s
On Fri, 30 May 2003, Bruno Wolff III wrote:
> Now that expressions can be used in indexes in 7.4 you can have multicolumn
> indexes that are ordered in different directions. However the planner
> doesn't seem to understand that order by -col asc is the same as order by
> col desc (for at least the
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Now that expressions can be used in indexes in 7.4 you can have multicolumn
> indexes that are ordered in different directions. However the planner
> doesn't seem to understand that order by -col asc is the same as order by
> col desc (for at least the