From: TJ O'Donnell <tjo@acm.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: TJ O'Donnell <tjo@acm.org>
Cc: PostgreSQL - SQL <pgsql-sql@postgresql.org>
Subject: Re: Create Table xtest (like xtype)
Date: Wed, 6 Feb 2008 16:37:16 -0800 (PST)
Message-ID: <3783.70.166.88.111.1202344636.squirrel@www.gnova.com> (raw)
In-Reply-To: <19826.1202340074@sss.pgh.pa.us>
References: <47AA0D2E.5040303@acm.org>
<19826.1202340074@sss.pgh.pa.us>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tjo@acm.org, tgl@sss.pgh.pa.us
Subject: Re: Create Table xtest (like xtype)
In-Reply-To: <3783.70.166.88.111.1202344636.squirrel@www.gnova.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox