From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(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:28:02 |
Message-ID: | 200101231728.MAA14979@candle.pha.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)
The text of the email showed this query returning columns from table c.
Seems it was just a mistake in the email.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Gordan Bobic | 2001-01-23 17:28:18 | Re: VACUUM and 24/7 database operation |
Previous Message | Tom Lane | 2001-01-23 17:13:28 | Re: Outer Joins |