diff options
author | Bruce Momjian <bruce@momjian.us> | 2020-04-02 17:42:09 -0400 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2020-04-02 17:42:09 -0400 |
commit | 68ef3037e4910ad95d80351b36c8f23f3e283121 (patch) | |
tree | e77a456334b0f33ed96ffeb8697ec4d425a38438 | |
parent | bd2cfe40f841d355c42dbf4a6ced35ca88bf6e23 (diff) |
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.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/pgbuffercache.sgml b/doc/src/sgml/pgbuffercache.sgml index d322eed44bf..39ffd4dc042 100644 --- a/doc/src/sgml/pgbuffercache.sgml +++ b/doc/src/sgml/pgbuffercache.sgml @@ -148,7 +148,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())) |