2011/5/18 Grzegorz Szpetkowski <gszpetkowski(at)gmail(dot)com>:
> "Finally, NATURAL is a shorthand form of USING: it forms a USING list
> consisting of all column names that appear in both input tables. As
> with USING, these columns appear only once in the output table."
> "NATURAL is shorthand for a USING list that mentions all columns in
> the two tables that have the same names."
> To make that comprehensive you can add something like: "Note that if
> there is no any "shared" column between tables, then NATURAL JOIN acts
> like ON TRUE (that is, tables are cross-joined)", because it's not
> thanks & regards,
> greg szpetkowski
My mistake "NATURAL JOIN", better is to just write "NATURAL".
thanks & regards,
In response to
pgsql-docs by date
|Next:||From: Robert Haas||Date: 2011-05-19 20:15:23|
|Subject: Re: createuser/dropuser username|
|Previous:||From: Grzegorz Szpetkowski||Date: 2011-05-18 01:47:00|
|Subject: 7.2. Table Expressions suggestion about NATURAL JOIN|