surprising behaviour on strings in postgresql

[Martin Schönbeck]

Hi,

i had to change a view used in selecting previous orderlines to check for a given entry in the description. So I added a "and ol.description <> 'TESTSTRING'". This worked fine when selecting from this view in dbeaver. But when using it in iDempiere it behaved like an oracle database and didn't select lines where description was null. Only changing it to

"and (ol.description <> 'TESTSTRING' or ol.description is null)" got it to work.

Is there any reason, why this view behaves as in oracle? I could imagine that iDempiere changes internally given selects to behave as in oracle. But results of view?

Any ideas?

Regards,

Martin