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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
