[firebird-support] Equality on NULL column values

2014-10-31 Thread 'Louis van Alphen' lo...@nucleo.co.za [firebird-support]
Hello all, I have a table that contains columns that describe an item. E.g. ITEM table ID bigint not null COLOUR bigint not null (indexed) FINISH bigint (indexed) Then another table that contains a qty of items that is reserved. I.e. the specification and qty of items reserved.

[firebird-support] Re: Equality on NULL column values

2014-10-31 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
31.10.2014 09:03, 'Louis van Alphen' wrote: and coalesce(R.FINISH,-1) = coalesce(STOCK.FINISH,-1) and R.FINISH is not distinct from STOCK.FINISH Dmitry

RE: [firebird-support] Re: Equality on NULL column values

2014-10-31 Thread 'Louis van Alphen' lo...@nucleo.co.za [firebird-support]
Thanks! Never too old to learn From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 31 October 2014 09:13 AM To: firebird-support@yahoogroups.com Subject: [firebird-support] Re: Equality on NULL column values 31.10.2014 09:03, 'Louis van Alphen'