yugabyte/yugabyte-db
Voir sur GitHub[docs] The YB doc account of SELECT misses the FETCH and FOR UPDATE clauses
Open
#6 147 ouverte le 25 oct. 2020
area/ysqlhelp wantedkind/enhancementpriority/medium
Métriques du dépôt
- Stars
- (8 229 stars)
- Métriques de merge PR
- (Merge moyen 17j 21h) (92 PRs mergées en 30 j)
Description
Jira Link: DB-2202
The PostgreSQL 11 documentation describes the FETCH clause thus:
[ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]
And it describes the FOR UPDATE clause thus:
[ FOR { UPDATE | NO KEY UPDATE | SHARE | KEY SHARE } [ OF table_name [, ...] ] [ NOWAIT | SKIP LOCKED ] [...] ]
But the YB doc for SELECT is missing these clauses altogether.