On lör, 2009-11-21 at 22:20 +0100, Florian G. Pflug wrote: > > I'm inclined to leave it alone. It complicates the mental model, and > > frankly attaching defaults to domains was not one of the SQL > > committee's better ideas anyway. It's *fundamentally* > > non-orthogonal. > > I've always though of domains as being a kind of subtype of it's base > type. In this picture, DEFAULTs for domains correspond to overriding the > default constructor of the type (thinking C++ now), and seem like a > natural thing to have. But maybe that's more a C++ programmers than a > database designers point of view...
There are other things in the SQL standard to do that, like types with inheritance and types with constructors. We have already overextended domains enough beyond what the SQL standards says, mostly because these other things that are the correct solution are not implemented yet. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
