Re: Create Table xtest (like xtype) - Mailing list pgsql-sql

From TJ O'Donnell
Subject Re: Create Table xtest (like xtype)
Date
Msg-id 3783.70.166.88.111.1202344636.squirrel@www.gnova.com
Whole thread Raw
In response to Re: Create Table xtest (like xtype)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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" <tjo@acm.org> 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
>




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Information schema permissions
Next
From: "Medi Montaseri"
Date:
Subject: accounting schema