date

I have tried the example from http://code.kx.com/wiki/JB:KdbplusForMortals/segments#1.4.3_Multiple_Segmented_Tables

But I don’t understand what is the date variable when a segmented table loaded? It seems the date variable contains dates from all segments but in ascending order. Why dates are reapeted not unique? Even if I delete this variable from the context, tables contains valid date columns, but select command if the date variable is used doesn’t work any more.

date’s length and values reflect those of the underlying partitions.
Do not delete or modify the date variable. If you want the unique values, you could use “distinct date”.
Note that multiple segmented tables is made somewhat redundant with kdb+v3.0 (64bit) as the 2 billion element in a vector limit has been removed.

thanks