Re: [GENERAL] not quite expected behaviour when using IN clause

2005-09-30 Thread Stephan Szabo
On Fri, 30 Sep 2005, Joe Maldonado wrote: > Hello all, > > I apologize for the wide distribution but we recently ran into an > interesting behaviour using PostgreSQL 8.0.3 and did not know whether this > was a bug or intended behaviour. > > When an IN clause contains a NULL value the entire in cla

[GENERAL] not quite expected behaviour when using IN clause

2005-09-30 Thread Joe Maldonado
Hello all, I apologize for the wide distribution but we recently ran into an interesting behaviour using PostgreSQL 8.0.3 and did not know whether this was a bug or intended behaviour. When an IN clause contains a NULL value the entire in clause is considered as being false, thus no records are r