Re: [chiPHPug-discuss] a bit of a sticky wicket...

[Peter H. <ph...@ma...>]

On Fri, Oct 12, 2007 at 11:25:26AM -0500, jsWalter wrote:
> > You don't mention whether cel_num or seq_num has higher priority.
> > Which of these two rows would be selected?
> >
> >  	ID         DATE     line_num  seq_num  cell_num  time
> > 1	APM	2007-10-02     2         0         1     6.00
> > 2	APM	2007-10-02     2         1         0     5.50
> 
> SEQ has higher priority than CELL
> 
> If multiple LINE, use higher SEQ
> If multiple SEQ, use higher CELL
> If multiple SEQ and multiple CELL are the same, keep all.

So in this example, #1 would be selected?


--
Peter Harkins  -  http://push.cx  -  http://NearbyGamers.com