Re: FROM ONLY in Postgres back-end

egroups.com [mailto: > django...@googlegroups.com ] On Behalf Of Christian > Ledermann > Sent: Wednesday, September 13, 2017 12:00 PM > To: django...@googlegroups.com > Subject: Re: FROM ONLY in Postgres back-end > > On 12 September 2017 at 14:32, Andrew Hankinson <andrew.h...

FROM ONLY in Postgres back-end

Hello, tl;dr I'm trying to implement 'temporal tables' [0] in Django with a Postgres backend, and I'm stuck on how to generate the appropriate SELECT ... FROM ONLY and UPDATE queries. The temporal tables pattern depends on having two mirror tables. For a simple example, let's call them