Frank Bax <fbax@sympatico.ca> writes:
> create or replace view vehicle as
> select 'car' as type,manufacturer,vin,color from car
> union
> select 'truck' as type,manufacturer,vin,color from truck
> union
> select 'suv' as type,manufacturer,vin,color from suv
> ;
UNION ALL would be better, since it would stop the system from uselessly
trying to eliminate duplicate rows ...
regards, tom lane