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