Re: On columnar storage

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