Re: FROM ONLY in Postgres back-end

2017-09-13 Thread Andrew Hankinson
inal Message- > From: django...@googlegroups.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 Septemb

RE: FROM ONLY in Postgres back-end

2017-09-13 Thread Matthew Pava
-Original Message- From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On Behalf Of Christian Ledermann Sent: Wednesday, September 13, 2017 12:00 PM To: django-users@googlegroups.com Subject: Re: FROM ONLY in Postgres back-end On 12 September 2017 at 14:32, Andrew Ha

Re: FROM ONLY in Postgres back-end

2017-09-13 Thread Christian Ledermann
On 12 September 2017 at 14:32, Andrew Hankinson wrote: > 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

FROM ONLY in Postgres back-end

2017-09-12 Thread Andrew Hankinson
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 "person