| From: | "Fernando Cano" <fcano(at)uniovi(dot)es> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #5506: Error in the grammar of de joins |
| Date: | 2010-06-14 08:40:34 |
| Message-ID: | 201006140840.o5E8eYm5083906@wwwmaster.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5506
Logged by: Fernando Cano
Email address: fcano(at)uniovi(dot)es
PostgreSQL version: 8.4
Operating system: Ubuntu 9.04
Description: Error in the grammar of de joins
Details:
This sentences are valid with your grammar but generate an error.
create table t1 ( id_t1 smallint, name text);
create table t2 ( id_t2 smallint, name text);
select * from natural join using (id) ;
select * from t1 natural cross join t2;
select * from natural cross join using (id) ;
select * from t1 join t2;
select t1 natural left join t2;
I have problems when I explain to my students the sintax of the joins.
I use this sintax, but I'm not sure:
from_item {CROSS | NATURAL join_type } JOIN from_item
from_item join_type JOIN from_item [ ON join_condition | USING ( join_column
[, ...] ) ]
where join_type is:
[ INNER ] | {LEFT |RIGHT | FULL} [ OUTER ]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shinji Nakajima | 2010-06-14 10:28:36 | BUG #5507: missing chunk number 0 for toast value XXXXX in pg_toast_XXXXX |
| Previous Message | Tommy McDaniel | 2010-06-14 08:28:06 | BUG #5505: Busted referential integrity with triggers |