Re: order of clauses

From: "Steve Wolfe" <steve(at)iboats(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: order of clauses
Date: 2001-02-16 20:10:16
Message-ID: 00b701c09854$7c76a900$50824e40@iboats.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > will give a divide by zero error as A=(y>0) and B=(x/y>1) can be
evaluated in
> > any order (A and B = B and A). I obviously would like (y>0) to happen
first,
> > but I don't see how this can be achieved.. Any ideas?

I have one idea that would be nifty to implement. In some compilers, you
can turn off complete boolean checking. As soon as any part of an
expression will invalidate the expression, it stops evaluating all of it.
That can help you avoid division by zero, and keeps you from evaluating
parts of the expression that don't matter. It sounds like a good idea, at
least to an ignoramus like me. : )

steve

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fork 2001-02-16 20:11:32 Re: Case insensitive selects?
Previous Message Gregory Wood 2001-02-16 20:09:00 Re: Postgres slowdown on large table joins