On Thu, 8 Jan 2026, Tom Lane wrote:
AND binds more tightly than OR. I think you meant where p.email is not null and (industry = 'Chemicals' or industry = 'Energy' or industry = 'Food processor' or industry = 'Manufacturing' or industry = 'Maritime' or industry = 'Transportation' or industry = 'Wood products')
Tom, While I'm aware that AND binds tigher than OR, I totally missed the need to package all industry names within parentheses.
BTW, using IN might make this more compact.
And, it enforces industry types to be in parentheses. Thanks very much, Rich
