Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)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