On Thu, 31 Jul 2003, maillist wrote: > select * from apps where (not apppag = null); > returns nothing when it should return every thing
No. It should return nothing. apppag = null returns unknown for every row. Use IS NULL to test if a value is null. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org