From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Andrew Smith <laconical(at)gmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Enhancement to SQL query capabilities |
Date: | 2016-03-18 13:17:00 |
Message-ID: | 15320.1458307020@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Andrew Smith <laconical(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Moore | 2016-03-18 21:06:16 | recursive WITH nested union ALL with NOCYCLE logic |
Previous Message | Mike Sofen | 2016-03-18 12:21:51 | Re: Enhancement to SQL query capabilities |