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 | d269f858b40fd7dcd0bc63a70d7d340d902afe1e (patch) | |
tree | 128813c0d5cdfe747cc47d8667e0d285838e2de7 | |
parent | bf09e83dbc8ba8196b10170976fd55aa2182d82b (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())) |