John Siracusa <[EMAIL PROTECTED]> writes:
> ... Actually, I'm still not sure how you
> can conclude that foo is not null simply by seeing func(..., foo, ...) where
> func() is strict. Do strict functions and operators simply not allow null
> args?
Advertising
That was what the comments were about ;-). A "strict" operator is one
that always returns NULL if any input is NULL. This does guarantee that
the WHERE condition will fail, but it takes a bit of analysis to see
that the implication is valid.
> Here's hoping that my next performance enhancement suggestion will be
> complex enough that no one will entertain the thought of asking me for a
> patch... ;)
I had quite the opposite motivation in mind in asking you to prototype
this ;-) ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
