[ts-gen] New series

R P Herrold herrold at owlriver.com
Sat Dec 27 21:52:07 EST 2008


On Sat, 27 Dec 2008, Nils Gebhardt wrote:

> Also convenient might be to collect tags from the var column in
> CreateEvent for open orders for example:
> * select  var from CreateEvent, OrderStatus where mark = something,  not
> Status = filled, key?

The contents in the 'mark' column are under downstream 
control, subject only to the character set limitations. 
Probably you would use the 96 char wide 'mark' field with a 
'generated'E
 	[think: "a-YYYYMMDD-ClientNo-StratNo-TicketNo-more"]
value, to permit 'slicing and dicing' pieces of data

    select (fields) from CreateEvent where mark like 
'%pattern%' ...

and accept the linear search time which such a query needs to 
walk the table for matches

-- Russ herrold


More information about the ts-general mailing list