Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Emil ObermayrDate: 2008-12-18 20:54:13
Subject: Re: SQL Question
Previous:From: Stephen ChoulartonDate: 2008-12-18 18:49:06
Subject: internet explorer patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group