X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 061735E46F9 for ; Wed, 1 Sep 2004 19:41:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33427-09 for ; Wed, 1 Sep 2004 22:41:27 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4C6195E46C1 for ; Wed, 1 Sep 2004 19:41:25 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i81MfPD4010959; Wed, 1 Sep 2004 18:41:25 -0400 (EDT) To: "Traci Sumpter" Cc: pgsql-sql@postgresql.org Subject: Re: Defining Field Types with view In-reply-to: References: Comments: In-reply-to "Traci Sumpter" message dated "Thu, 02 Sep 2004 08:27:14 +1200" Date: Wed, 01 Sep 2004 18:41:25 -0400 Message-ID: <10958.1094078485@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/23 X-Sequence-Number: 18869 "Traci Sumpter" writes: > Cheesy one here.... Got a cheesy answer for you --- cast the result ... regression=# create view voo as regression-# select f1::varchar(20) from regression-# (select f1 from foo union select f2 from foo) ss; CREATE VIEW regression=# \d voo View "public.voo" Column | Type | Modifiers --------+-----------------------+----------- f1 | character varying(20) | View definition: SELECT ss.f1::character varying(20) AS f1 FROM ( SELECT foo.f1 FROM foo UNION SELECT foo.f2 FROM foo) ss; regards, tom lane