where dType IS NULL
is what you should use for testing NULL.
However using should also work so something else is also going on there from
the sounds of it. Can you post the code perhaps?
HTH
cheers
Alan
On 18/06/2013, at 12:00 PM, use-livecode-requ...@lists.runrev.com wrote:
After
After inserting a new column into a postgres table, I'm unable to find
a way to match it in a query.
With the new column dTyp CHAR(1) added, and set to E in a couple of places,
SELECT kywd FROM myTable WHERE dTyp=NULL;
should select all of the other entries, shouldn't it?
I've also tried