X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id B1121EFF9E for ; Fri, 6 Jun 2003 14:51:30 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 20291-06 for ; Fri, 6 Jun 2003 14:51:29 +0000 (GMT) Received: from www.postgresql.com (www.postgresql.com [64.117.225.209]) by svr1.postgresql.org (Postfix) with ESMTP id B89C2F0164 for ; Fri, 6 Jun 2003 14:48:01 +0000 (GMT) Received: from web12701.mail.yahoo.com (web12701.mail.yahoo.com [216.136.173.238]) by www.postgresql.com (Postfix) with SMTP id C4871CF8386 for ; Thu, 5 Jun 2003 21:39:08 +0000 (GMT) Message-ID: <20030605213807.40591.qmail@web12701.mail.yahoo.com> Received: from [63.230.97.206] by web12701.mail.yahoo.com via HTTP; Thu, 05 Jun 2003 14:38:07 PDT Date: Thu, 5 Jun 2003 14:38:07 -0700 (PDT) From: chester c young Subject: Domains and Joins To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200306/44 X-Sequence-Number: 13802 -- standard setup: create table t1( c1 int primary key, data text ); create domain dom_c1 int references t1 on delete cascade; create table t2( c2 int primary key, c1 dom_c1, moredata text ); -- will not work with "using" create view v1 as select t1.*, t2.moredata from t1 join t2 using( c1 ); -- will work with "on" create view v1 as select t1.*, t2.moredata from t1 join t2 on t1.c1 = t2.c1; is this right? __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com