C GG <cgg0007(at)gmail(dot)com> writes:> ... Is PostgreSQL smart enough to not have to rewrite the table and simply> shed the domain for the underlying datatype?
Yes, in recent versions ... don't remember how far back exactly.
regards, tom lane