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 inse
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
W
