Does FILTER in SEQSCAN short-circuit AND? - Mailing list pgsql-performance

From Carlo Stonebanks
Subject Does FILTER in SEQSCAN short-circuit AND?
Date
Msg-id hsv49v$312j$1@news.hub.org
Whole thread Raw
Responses Re: Does FILTER in SEQSCAN short-circuit AND?
Re: Does FILTER in SEQSCAN short-circuit AND?
List pgsql-performance
Sample code:

SELECT *
FROM MyTable
WHERE foo = 'bar' AND MySlowFunc('foo') = 'bar'

Let's say this required a SEQSCAN because there were no indexes to support
column foo. For every row where foo <> 'bar' would the filter on the SEQSCAN
short-circuit the AND return false right away, or would it still execute
MySlowFunc('foo') ?

Thanks!

Carlo


pgsql-performance by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: Random Page Cost and Planner
Next
From: "Kevin Grittner"
Date:
Subject: Re: Does FILTER in SEQSCAN short-circuit AND?