Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7F2452E33C4 for ; Wed, 6 Feb 2008 20:48:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96803-05 for ; Wed, 6 Feb 2008 20:48:43 -0400 (AST) Received: from dukecmmtao03.coxmail.com (dukecmmtao03.coxmail.com [68.99.120.70]) by postgresql.org (Postfix) with ESMTP id 840362E33A5 for ; Wed, 6 Feb 2008 20:48:43 -0400 (AST) Received: from newton.gnova.com ([70.166.0.90]) by dukecmmtar02.coxmail.com (InterMail vM.6.01.06.01 201-2131-130-101-20060113) with ESMTP id <20080207003813.OFUT1539.dukecmmtar02.coxmail.com@newton.gnova.com>; Wed, 6 Feb 2008 19:38:13 -0500 Received: from www.gnova.com (localhost.localdomain [127.0.0.1]) by newton.gnova.com (8.13.1/8.13.1) with ESMTP id m170bFDC013482; Wed, 6 Feb 2008 16:37:16 -0800 Received: from wsip-70-166-88-111.sd.sd.cox.net ([70.166.88.111]) (SquirrelMail authenticated user tjo) by www.gnova.com with HTTP; Wed, 6 Feb 2008 16:37:16 -0800 (PST) Message-ID: <3783.70.166.88.111.1202344636.squirrel@www.gnova.com> In-Reply-To: <19826.1202340074@sss.pgh.pa.us> References: <47AA0D2E.5040303@acm.org> <19826.1202340074@sss.pgh.pa.us> Date: Wed, 6 Feb 2008 16:37:16 -0800 (PST) Subject: Re: Create Table xtest (like xtype) From: "TJ O'Donnell" To: "Tom Lane" Cc: "TJ O'Donnell" , "PostgreSQL - SQL" Reply-To: tjo@acm.org User-Agent: SquirrelMail/1.4.8 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/45 X-Sequence-Number: 30136 Considering how related Created Types and Tables are (at least conceptually) it seems like a good idea to allow Created Types to be used in the Like clause. At least it would help me and make maintaining my db easier and cleaner. TJ O'Donnell http://www.gnova.com/ > "TJ O'Donnell" writes: >> Create Type xtype As (a Integer, b Text); >> Create Table xtest (Like xtype); >> ERROR: "xtype" is a composite type > > Hmmm ... as you see, that's disallowed, but offhand it seems like it > wouldn't be very hard to allow it. It might be as simple as relaxing > the relkind check. > > regards, tom lane >