Data type for a complex column

Community Support
1

how do i specify the data type for a column that should hold a list ofvaluesBy doing thist: ( a:`int$(); b:())i can insert a list of values in b but is there a way to define thatb will take a list of values during table definition?Thanks-Bharani

2

Bharani,
No, to my knowledge there is no way to specify that a column will hold for example a list of ints.
If you want a nested column, you have to define it as you defined column b below.
The datatype will be set on your first insert.

Eg:
q)t: ( a:`int$(); b:())
q)
q)t
a b

q)
q)meta t

c t f a
a i
b
q)
q)`t insert (1;10?100)
,0
q)
q)t
a b

1 12 10 1 90 73 90 43 90 84 63
q)meta t

c t f a
a i
b I

Regards,
Nathan

2009/8/14 bharani <bharani_vms@yahoo.com>

how do i specify the data type for a column that should hold a list of
values

By doing this
t: ( a:`int$(); b:())

i can insert a list of values in b ?but is there a way to define that
b will take a list of values during table definition?

Thanks
-Bharani