Re: NATURAL JOINs - Mailing list pgsql-general

From Tom Lane
Subject Re: NATURAL JOINs
Date
Msg-id 22338.1224086103@sss.pgh.pa.us
Whole thread Raw
In response to Re: NATURAL JOINs  ("Richard Broersma" <richard.broersma@gmail.com>)
Responses Re: NATURAL JOINs  (Reg Me Please <regmeplease@gmail.com>)
List pgsql-general
"Richard Broersma" <richard.broersma@gmail.com> writes:
> For this reason, clients passing natural joins to the server can have
> dangerous result sets returned with no warning.

Yeah.  A lot of people consider that NATURAL JOIN is simply a bad idea
and shouldn't be used ever --- it's too easy to shoot yourself in the
foot with a careless column addition or rename.  Explicitly spelling out
the join columns with ON or USING is a lot less prone to silent breakage
after a schema change.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Opptimizing projections containing unused columns
Next
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: Opptimizing projections containing unused columns