"Chris Velevitch" <chris.velevitch@xxxxxxxxx> writes: > What is the point of the create or replace view command if you can't > change the column and data types ? You might as well ask what's the point of CREATE OR REPLACE FUNCTION, when it doesn't let you change the function's parameter list or result type. The analogy to result type is pretty exact, in fact. regards, tom lane