matching empty/uninitialized database entries

[Alan Stenhouse]

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-request at 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'"