| 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: | Whole Thread | Raw Message | 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 | 
| 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 |