Random access result sets
Furnace framework » Database library » Low-level database protocol » Result sets

Next:Sequential result sets

Random-access result sets do not have to be traversed in order. For instance, PostgreSQL's result set object can be accessed as a matrix with i,j coordinates.

Databases which work in this way must provide methods for the following traversal words:
#rows ( result-set -- n )

#columns ( result-set -- n )

row-column ( result-set column -- obj )

row-column-typed ( result-set column -- sql )