On 6/17/15 2:04 PM, Alvaro Herrera wrote:
> Jim Nasby wrote:
>
>> Related to idea of an 'auto join', I do wish we had the ability to access
>> columns in a referenced FK table from a referring key; something like SELECT
>> customer_id.first_name FROM invoice (which would be translated to SELECT
>> first_name FROM invoice JOIN customer USING( customer_id )).
>
> We already have this feature -- you just need to set the
> add_missing_from GUC.
>
> (... actually we removed that feature because it was considered
> dangerous or something.)
That was removed in 9.0. Even so, I don't believe it added the JOIN, so
you'd suddenly get a Cartesian product.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com