On Thu, 23 Sep 2004 10:40:48 +1000 (EST), Nuno Pinto do Souto <nsouto@xxxxxxxxxxxxxx> wrote: > Quoting from AUTHOR ryan gaffuri: > > 11. Thou shalt feed me if I have to work late to fix something you > > broke. > > > > I'm a single guy... > > > Nuno's design corollary #1: > > Thou shall not use end_date = NULL to mean "current row" of ANYTHING! > NULL has NO MEANING whatsoever: it does NOT mean "current"! true. But that doesn't mean you can use December 31st 2099 to mean no end date recorded either... -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com -- //www.freelists.org/webpage/oracle-l