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(dot)Schoening(at)AM-SoFT(dot)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