x <> 0 is evaluated first, 1/x only when x <> 0, not ?

czw., 31 paź 2019 o 16:45 Tom Lane <t...@sss.pgh.pa.us> napisał(a):

> Andres Freund <and...@anarazel.de> writes:
> > Potentially related note: for nodes like seqscan, combining the qual and
> projection processing into one expression seems to be a noticable win (at
> least when taking care do emit two different sets of deform expression
> steps).
>
> There's just one problem: that violates SQL semantics, and not in
> a small way.
>
>         select 1/x from tab where x <> 0
>
>                         regards, tom lane
>

Reply via email to