yugabyte/yugabyte-db

[docs] The YB doc account of SELECT misses the FETCH and FOR UPDATE clauses

Open

#6 147 ouverte le 25 oct. 2020

Voir sur GitHub
 (0 commentaires) (0 réactions) (0 assignés)C (1 003 forks)batch import
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.

Guide contributeur