postgreSQL.cursor.fetchAllRows

Syntax

postgreSQL.cursor.fetchAllRows (cursorRef, adrRows, ctRows, as, flCoerceToUserTalkTypes)

Params

cursorRef is a reference to a cursor as returned by postgreSQL.cursor.create.

adrRows is the address of the variable where the result will be stored.

as is an optional string4 value indicating the desired result type. Default is listType.

flCoerceToUserTalkTypes is an optional boolean indicating whether PostgreSQL values in the rows should be converted to corresponding UserTalkTypes. Default is true.

Action

Fetch all remaining rows from the last result set generated by a query or procedure call.

Returns

A boolean that is true if at least one row was fetched, or false if there are no more rows waiting to be fetched.

Examples

postgreSQL.cursor.fetchAllRows (cursorRef, @rowList, recordType)

« true //rowList now contains e.g. {{"first":"Ian", "last":"O'Sullivan", "age":48}, {"first":"Bull", "last":"Mancuso", "age":41}}

Notes

This verb is equivalent to calling postgreSQL.cursor.fetchMultipleRows with the ctRows parameter set to the number of remaining rows in the result set.

See Also

postgreSQL.cursor.executeQuery

postgreSQL.cursor.executeMultipleQueries

postgreSQL.cursor.callProcedure

postgreSQL.cursor.getDescription

postgreSQL.cursor.fetchOneRow

postgreSQL.cursor.fetchMultipleRows