I'd like to join two tables in Postgres, but only if the value is not NULL in both fields.
It appears to me that a query like this will actually behave like this already, without further conditionals:
SELECT * FROM aTable a JOIN bTable b on a.value=b.value;
This doesn't return rows from my database where both a.value and b.value are NULL.
However, I'm not totally confident I understand what's going on. Is this because NULL is not equal to NULL in Postgres?
© 2016 Powered by mzan.com design MATCHINFO