Is there a fast way to get the result of a select as list of lists and not as a flat list?

db1 eval {INSERT INTO t1 VALUES(1,'hello')}
db1 eval {INSERT INTO t1 VALUES(2,'goodbye')}
db1 eval {INSERT INTO t1 VALUES(3,'howdy!')}
set x [db1 eval {SELECT * FROM t1}]

Now i get a flat list:

1 hello 2 goodbye 3 howdy!


but i would prefer to have


set x [db1 evallist {SELECT * FROM t1}]


{1 hello} {2 goodbye} {3 howdy!}


They way I used so far seems not to be the fastest (especially for larger data sets):



set _res_ {} db eval {SELECT * FROM t1} _values_ { set _tmp_ {} foreach _part_ $_values_(*) { lappend _tmp_ $_values_(${_part_}) } lappend _res_ ${_tmp_} }


TIA


Stefan



Reply via email to