[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