From: chester c young <chestercyoung@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Domains and Joins
Date: Thu, 5 Jun 2003 14:38:07 -0700 (PDT)
Message-ID: <20030605213807.40591.qmail@web12701.mail.yahoo.com> (raw)
-- 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
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: chestercyoung@yahoo.com
Subject: Re: Domains and Joins
In-Reply-To: <20030605213807.40591.qmail@web12701.mail.yahoo.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