sanjay raj

A member of the Philip Greenspun's Homepage community since August 25, 2005

If you were to log in, you'd be able to get more information on your fellow community member.

August 25, 2005, on Views:
In this on views you state that condition "classified_ads.posted > '1999-01-01' " will not give the desired results because the column 'posted' is nullable hence this condition will compute to NULL whenever 'posted' column is NULL. Hence the query will never return rows where 'posted' value is NULL. And in order to solve this issue you go onto to create a view with the following query: (select * from classified_ads where posted > '1999-01-01') Wont this view suffer from the same issue? Why will this view contain columns where 'posted' column is NULL. Please explain.