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 | de7561f7d87df7dff8c6b29ac0d6435795d42372 (patch) | |
tree | 414c4293b0b4444003769d1a4bae0f63adc59ac8 | |
parent | 8a043d8673289c2a0c6256fc15cc641bb91c5674 (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 cd881210494..ddf97c88ea4 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())) |