Postgres Pro
Downloads
Home   >   mailing lists

SQL Question - Mailing list pgsql-novice

From Yogesh Sharma
Subject SQL Question
Date
Msg-id 494AB040.70507@catprosystems.com
Whole thread Raw
Responses Re: SQL Question
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Steve T
Date:
Subject: Re: customizable web reporting tools
Next
From: Emil Obermayr
Date:
Subject: Re: SQL Question