Re: SQL: Working with huge tables of chronological data

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 06 Apr 2007 09:02:37 -0700
Message-ID: <1175875353.39697@bubbleator.drizzle.com>

John wrote:
> On Apr 5, 3:50 pm, "John" <acide.ascorbi..._at_gmail.com> wrote:

>>> Is this the real problem or a simplification?
>> It's a simplification but not that much. The real problem involves
>> user_ids but this part can be skipped here.
>>
>>> Is this something that will be run once or repeatedly?
>> Only once.
>>
>>> Is it possible for the same time to be in A and B?
>> No, A and B are completely different data.

>
> Ho I misunderstood the question. I understood the question as "can A
> and B have the same values ?", which answer is no. But yes, A and B
> can have the same timestamp.
>
> Sorry, thanks for helping,
>
> John

I guess the professor just comes out in me but Ok ... given they can have the same timestamp ... when they do ... does B come before A or after A.

Even the simple can grow rather complex when all possibilities are considered. <g>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri Apr 06 2007 - 11:02:37 CDT