Re: field definitions in view results?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: field definitions in view results?
Date: 2005-04-04 15:14:02
Message-ID: 26108.1112627642@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karl O. Pinc 2005-04-04 15:15:29 Vacuum, statistics, & trigger/procedure query plan caching
Previous Message Joshua D. Drake 2005-04-04 15:03:50 Re: [HACKERS] plPHP in core?