On Wed, 2005-01-19 at 22:20, Alex wrote: > > Maybe there could be an option in the creation of the index to indicate > on how to use NULL values. > > How do other DBMS handle this? http://troels.arvin.dk/db/rdbms/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match