Re: How to properly query lots of rows based on timestamps?

Guten Tag Tom Lane,
am Samstag, 29. August 2020 um 17:19 schrieben Sie:

> TBH, this seems like a pretty awful data design.  If you included the
> timestamp column into oms_rec, and had an index on it, then you would
> not need a join at all.

clt_rec and oms_rec are different types of data and only the former
includes the timestamp, that's simply how the stored data works. So if
at all, oms_rec needs to be embedded into clt_rec entirely. While I
considered that in the past already, wasn't sure if that is the best
approach to model those two different data types.

I'll make a note and consider refactoring at some point, so thanks for
your opinion!

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning       E-Mail: Thorsten.Schoening@AM-SoFT.de
AM-SoFT IT-Systeme      http://www.AM-SoFT.de/

Telefon...........05151-  9468- 55
Fax...............05151-  9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow