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.) -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
