Hi,
Two tables
Table_Master
id bigint
t1 timestamp with time zone
t2 timestamp with time zone
PK is id,t1
Table_Data
ts timestamp with time zone
data text
pk is ts
like to get all rows from table_data where ts is between table_master.t1
and table_master.t2 for a given id.
Thanks