Re: Documentation enancement regarding NULL and operators

2024-12-18 Thread Adrian Klaver
On 12/15/24 09:35, Luca Dametto wrote: Hi All, I'm coming from hours of debugging a SQL trigger that wasn't working properly. After a beautiful headache and infinite hours of documentation reading I've found out that something doesn't work as I would expect. Most programming languages return

Re: Documentation enancement regarding NULL and operators

2024-12-18 Thread Laurenz Albe
On Sun, 2024-12-15 at 17:35 +, Luca Dametto wrote: > Most programming languages return "true" when two null values are compared, > and false when, being the two values nullable, one of them is null and the > other one isn't. > > [not SQL, however] > > Whilst I'd love to discuss the reasons of

Documentation enancement regarding NULL and operators

2024-12-18 Thread Luca Dametto
Hi All, I'm coming from hours of debugging a SQL trigger that wasn't working properly. After a beautiful headache and infinite hours of documentation reading I've found out that something doesn't work as I would expect. Most programming languages return "true" when two null values are compare