¶
3.12.3. Simple Tutorial
The following example prints the result from executing explain:
<?vsp declare meta, data any; exec ('explain (?)', null, null, vector ('select * from sys_users'), 0, meta, data); foreach (any row in data) do { http_value (row[0], 'p'); } ?>
The vsp can be also written like this:
<?vsp declare meta, data any; exec ('explain (?)', null, null, vector ('select * from sys_users'), 0, meta, data); for (declare i,l int, i := 0, l := length (data); i < l; i := i + 1) { http_value (data[i][0], 'p'); } ?>