SQL Question

From: Yogesh Sharma <ysharma(at)catprosystems(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: SQL Question
Date: 2008-12-18 20:19:12
Message-ID: 494AB040.70507@catprosystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Emil Obermayr 2008-12-18 20:54:13 Re: SQL Question
Previous Message Stephen Choularton 2008-12-18 18:49:06 internet explorer patch