Mikael Kjellström wrote: > BTW isn't the "preferred" way of writing different from / not equal in SQL > to use the <> operator?
Yes, <> is the operator mandated by the SQL standard. I don't think != appears anywhere -- it's our extension only and thus if you use it you should not expect your applications to work on other DBMSs. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services