Klint Gore <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly