| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com>, "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk>, Michael Dunn <michael(at)2cactus(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Outer Joins |
| Date: | 2001-01-23 17:13:28 |
| Message-ID: | 6803.980270008@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Can someone explain why cname and date from table c gets printed in this
> query?
Say what?
test=# CREATE TABLE a (id INTEGER, name TEXT, aname TEXT);
CREATE
test=# CREATE TABLE b (id INTEGER, name TEXT, bname TEXT);
CREATE
test=# CREATE TABLE c (id INTEGER, name TEXT, cname TEXT, date DATE DEFAULT
test(# CURRENT_DATE);
CREATE
test=# SELECT * FROM a FULL OUTER JOIN b USING (id);
id | name | aname | name | bname
----+------+-------+------+-------
(0 rows)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-01-23 17:28:02 | Re: Outer Joins |
| Previous Message | Steve Wolfe | 2001-01-23 17:11:17 | Re: "recovery mode" |