from_pgsql_key_set
Definition
/**
* Create a PostgreSQL extractor using keyset (cursor-based) pagination.
*
* More efficient than LIMIT/OFFSET for large datasets - uses indexed WHERE conditions
* instead of skipping rows.
*
* @param Client $client PostgreSQL client
* @param Sql|string $query SQL query to execute (must have ORDER BY matching keyset columns)
* @param KeySet $keySet Columns to use for keyset pagination
* @param list<mixed> $parameters Values bound by position to $1, $2, ... placeholders; wrap with {@see \Flow\PostgreSql\DSL\typed()} to force a specific PostgreSQL type
*/
from_pgsql_key_set(Client $client, Sql|string $query, KeySet $keySet, array $parameters) : PostgreSqlKeySetExtractor