Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitff4c69e

Browse files
committed
Fix up JOIN .. USING with domains
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. Asimple getBaseType() call on all elements of the list seems to beenough.--Rod Taylor <rbt@rbt.ca>
1 parentfaa8c75 commitff4c69e

File tree

1 file changed

+3
-3
lines changed

1 file changed

+3
-3
lines changed

‎src/backend/parser/parse_coerce.c‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
*
99
*
1010
* IDENTIFICATION
11-
* $Header: /cvsroot/pgsql/src/backend/parser/parse_coerce.c,v 2.98 2003/06/24 23:14:45 momjian Exp $
11+
* $Header: /cvsroot/pgsql/src/backend/parser/parse_coerce.c,v 2.99 2003/06/25 04:32:03 momjian Exp $
1212
*
1313
*-------------------------------------------------------------------------
1414
*/
@@ -599,11 +599,11 @@ select_common_type(List *typeids, const char *context)
599599
List*l;
600600

601601
Assert(typeids!=NIL);
602-
ptype=lfirsto(typeids);
602+
ptype=getBaseType(lfirsto(typeids));
603603
pcategory=TypeCategory(ptype);
604604
foreach(l,lnext(typeids))
605605
{
606-
Oidntype=lfirsto(l);
606+
Oidntype=getBaseType(lfirsto(l));
607607

608608
/* move on to next one if no new information... */
609609
if ((ntype!=InvalidOid)&& (ntype!=UNKNOWNOID)&& (ntype!=ptype))

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp