Re: DEFAULT of domain ignored in plpgsql (8.4.1)

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.