Re: domains aren't subtypes, right?
Date: Fri, 23 May 2003 12:27:46 -0700
Message-ID: <qJuza.8$Kj7.111_at_news.oracle.com>
"Peter Koch Larsen" <pkl_at_mailme.dk> wrote in message
news:3ece6a88$0$5145$edfadb0f_at_dread11.news.tele.dk...
> Well, I do understand your humor as there is no mathematically correct
way
> to determine whether one way of inheritance is better then another: as for
> many other areas in programming (and life!), You need to be pragmatic and
> define something that looks right - given the constraints of the
underlying
> language.
Well, if I want to be pragmatic, I define city as VARCHAR2 column in the database. No user defined types. Unless, I want to explore if optimizer is doing really good job collecting column statistics for user-defined types, generates plans properly, etc, etc. Same argument against composite type (ZIP CODE, ZIP EXTENSION). A miniscule programming convenience of combining 2 strings into a structure (it isn't really a complex class with many many methods, or is it?) would be far overwhelmed by surprises you encounter at database implementation side. Received on Fri May 23 2003 - 21:27:46 CEST