Re: Is This the varchar2 ZLS Issue?

From: Tony Andrews <andrewst_at_onetel.com>
Date: 22 Mar 2006 06:44:30 -0800
Message-ID: <1143038670.743328.86910@e56g2000cwe.googlegroups.com>

frank.van.bortel_at_gmail.com wrote:
> Hmmm, yes - wrong example. Read it with end_date instead of # of children.

Yes, that's a much better example.

> Or would someone introduce "special" dates, like september, 9th, 9999
> just to satisfy some rule?!?

No doubt some would, but that has its own issues.

A relational purist might say you need 2 tables - one to hold all the columns except end_date, and another to hold just PK + end_date. That's the ultimate in normalisation! Received on Wed Mar 22 2006 - 08:44:30 CST