Fix up JOIN .. USING with domains

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Fix up JOIN .. USING with domains
Date: 2003-06-08 13:57:57
Message-ID: 1055080677.23997.72.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

The attached fixes select_common_type() to support the below case:

create table t1( c1 int);
create domain dom_c1 int;
create table t2(c1 dom_c1);
select * from t1 join t2 using( c1 );

I didn't see a need for maintaining the domain as the preferred type. A
simple getBaseType() call on all elements of the list seems to be
enough.

--
Rod Taylor <rbt(at)rbt(dot)ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

Attachment Content-Type Size
joinusing.patch text/x-patch 1.1 KB

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2003-06-09 01:16:51 Re: Detecting proper bison version before make
Previous Message Peter Eisentraut 2003-06-08 09:49:11 Re: [BUGS] Detecting proper bison version before make