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 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 > WHERE dTyp='' > WHERE dTyp !~ '[a-zA-Z]' > > but none yield any results. > > Even > WHERE dTyp <> 'E'; > > yields no results. > > Am I missing something obvious? > > (I do get the correct result for "WHERE dTyp='E'" _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
