Re: Tricky ordering question

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 6 Apr 2006 08:15:13 -0400
Message-ID: <2LudnVszicLJm6jZnZ2dnUVZ_vidnZ2d@comcast.com>

"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:C56dnSPqxOh0fanZnZ2dnUVZ8qidnZ2d_at_giganews.com...
: Vladimir M. Zakharychev wrote:
: > "Doc Waters" <davidmwaters_at_yahoo.com> wrote in message
news:1144302517.051761.280780_at_u72g2000cwu.googlegroups.com...
: >> Why can't you just order by the timestamp column???
: >>
: >
: > Since different players' moves can have the same timestamp
: > (can hardly imagine this, but OP says they can :),
: > ordering by timestamp alone wouldn't be enough, but order
: > by timestamp,player_id should do the trick.
: Give each move a sequence number. Then order by timestamp, sequence_id.

: Lots of Greetings!
: Volker

this will only work if only if the sequence is created with the ORDER clause (NOORDER is the default)

but given the timestamp column includes subseconds, how likely is it that even a real-time poker-move data acquisition implant would come up with more than one player with the same timestamp?

++ mcs Received on Thu Apr 06 2006 - 07:15:13 CDT