aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2020-04-02 17:42:09 -0400
committerBruce Momjian <bruce@momjian.us>2020-04-02 17:42:09 -0400
commitbc96699b8f8d7ab4c91dbd15c53fbf9635bfee8b (patch)
treed6b0c51f43d11a2b4caed8c10e8f5fcee42f8bfd
parentaa9749ed95cadb8478e98fec15ed37fb83faa2ef (diff)
downloadpostgresql-bc96699b8f8d7ab4c91dbd15c53fbf9635bfee8b.tar.gz
postgresql-bc96699b8f8d7ab4c91dbd15c53fbf9635bfee8b.zip
doc: remove unnecessary INNER keyword
A join that was added in commit 9b2009c4cf that did not use the INNER keyword but the existing query used it. It was cleaner to remove the existing INNER keyword. Reported-by: Peter Eisentraut Discussion: https://postgr.es/m/a1ffbfda-59d2-5732-e5fb-3df8582b6434@2ndquadrant.com Backpatch-through: 9.5
-rw-r--r--doc/src/sgml/pgbuffercache.sgml2
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/pgbuffercache.sgml b/doc/src/sgml/pgbuffercache.sgml
index 2479181c5f4..fd2446d6542 100644
--- a/doc/src/sgml/pgbuffercache.sgml
+++ b/doc/src/sgml/pgbuffercache.sgml
@@ -149,7 +149,7 @@
<screen>
regression=# SELECT n.nspname, c.relname, count(*) AS buffers
- FROM pg_buffercache b INNER JOIN pg_class c
+ FROM pg_buffercache b JOIN pg_class c
ON b.relfilenode = pg_relation_filenode(c.oid) AND
b.reldatabase IN (0, (SELECT oid FROM pg_database
WHERE datname = current_database()))