På søndag 04. mai 2014 kl. 18:49:43, skrev Brice André <brice(at)famille-andre(dot)be
<mailto:brice(at)famille-andre(dot)be>>: Yes, I was a bit too fast. but replace it with
WHERE NOT prop.is_read = TRUE
and it should be OK. No, that also will be treated as an INNER JOIN,
because it kills tuples where prop is null. I need entries where prop IS NULL
(hence the LEFT OUTER JOIN) because messages without an entry in
message_property must be treated as unread, the same as messages with an entry
in message_property where is_read=FALSE. -- Andreas Jospeh Krogh CTO / Partner
- Visena AS Mobile: +47 909 56 963 andreas(at)visena(dot)com
<mailto:andreas(at)visena(dot)com> www.visena.com <https://www.visena.com>
<https://www.visena.com>