From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Smith <laconical@gmail.com>
cc: pgsql-sql@postgresql.org
Subject: Re: Enhancement to SQL query capabilities
In-reply-to: 
 <CALr=acHJbn1kiohs8upmSxN+JK5OWQ5=3LK5wp2PzGyiRK4oSA@mail.gmail.com>
References: 
 <CALr=acHJbn1kiohs8upmSxN+JK5OWQ5=3LK5wp2PzGyiRK4oSA@mail.gmail.com>
Comments: In-reply-to Andrew Smith <laconical@gmail.com>
	message dated "Fri, 18 Mar 2016 16:04:55 +1100"
Date: Fri, 18 Mar 2016 09:17:00 -0400
Message-ID: <15320.1458307020@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Andrew Smith <laconical@gmail.com> writes:
> Looking to migrate a software product to postgres coming from a home-grown
> DBMS. Whilst the majority of features in postgres are a gazillion times
> better than what our own DBMS has, one feature that I find I am missing is
> the ability to dereference foreign key fields in queries without having to
> join a bunch of tables together.

Aside from the other solutions that have been mentioned, have you
considered querying a view that contains the desired join?

There's no substitute for fixing that nonstandard syntax, in any case.
Even if you could persuade pgsql-hackers that the concept was good
(which I really doubt), they'd not go for using : as a selector.

			regards, tom lane


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql