yugabyte/yugabyte-db
[docs] The YB doc account of SELECT misses the FETCH and FOR UPDATE clauses
開放
#6,147 建立於 2020年10月25日
area/ysqlhelp wantedkind/enhancementpriority/medium
倉庫指標
- 星標
- (8,229 顆星)
- PR 合併指標
- (PR 指標待抓取)
描述
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.