Phil Endecott wrote:
> Dear Experts,
>
> I have two tables containing chronological data, and I want to join them
> using the timestamps. The challenge is that the timestamps only match
> approximately.
>
> My first attempt was something like
>
> t1 join t2 on (abs(t1.t-t2.t)<'1 min'::interva
On Tue, 20 Mar 2007 23:30:46 +, "Phil Endecott" <[EMAIL PROTECTED]> wrote:
> I have two tables containing chronological data, and I want to join
> them using the timestamps. The challenge is that the timestamps only
> match approximately.
>
> My first attempt was something like
>
>t1 j
Phil Endecott wrote:
Dear Experts,
I have two tables containing chronological data, and I want to join
them using the timestamps. The challenge is that the timestamps only
match approximately.
Hi Phil,
This is how we dealt with a similar situation. It may be suitable for
you
We hav
"Phil Endecott" <[EMAIL PROTECTED]> writes:
> I have two tables containing chronological data, and I want to join them using
> the timestamps. The challenge is that the timestamps only match
> approximately.
>
> My first attempt was something like
>
> t1 join t2 on (abs(t1.t-t2.t)<'1 min'::int
