Re: field definitions in view results?

Klint Gore <kg@kgb.une.edu.au> writes:
> Is there any way to get the (8) limit on the view result without doing
>   create view v1 as
>       select cast(v2.astr as varchar(8)) as astr
>       from (select * from t1 union select * from t2) v2

No.  This is an open issue for 8.1, see
http://archives.postgresql.org/pgsql-general/2004-12/msg00508.php
http://archives.postgresql.org/pgsql-hackers/2004-12/msg00408.php

            regards, tom lane