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" <[EMAIL PROTECTED]> 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 > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
