That's also the way it works in PostgreSQL. I think the view is actually compiled into a parse tree with named columns, and the view given a defined type iirc.

That's also the way it works in PostgreSQL. I think the view is actually compiled into a parse tree with named columns, and the view given a defined type iirc. (Select * from ... in PostgreSQL is actually really usefun in anything object-relational because you get objects of a named type back btw.)