2008/8/13 Osvaldo Kussama <[EMAIL PROTECTED]> > Ribamar: > > Talvez seja o caso descrito no manual: > > http://www.postgresql.org/docs/current/interactive/functions-subquery.html#AEN15302 > > "Note that if the left-hand expression yields null, or if there are no > equal right-hand values and at least one right-hand row yields null, > the result of the NOT IN construct will be null, not true. This is in > accordance with SQL's normal rules for Boolean combinations of null > values." > > A combinação de NULL com NOT IN nem sempre dá o resultado que > usualmente (bom senso?) esperamos. > > Osvaldo >
Osvaldo, parece que isso reforça a grande recomendação dos gurus e mestre: "Corram dos nulos!". Mas e se o bichim correr atraz da gente? :) -- Ribamar FS - [EMAIL PROTECTED] http://ribafs.net
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
