diff options
| -rw-r--r-- | doc/src/sgml/config.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 5549b7dce62..1da7dfbc5cd 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -4707,7 +4707,7 @@ local0.* /var/log/postgresql of printing those items. For example, to generate the session identifier from <literal>pg_stat_activity</>, use this query: <programlisting> -SELECT to_hex(EXTRACT(EPOCH FROM backend_start)::integer) || '.' || +SELECT to_hex(trunc(EXTRACT(EPOCH FROM backend_start))::integer) || '.' || to_hex(pid) FROM pg_stat_activity; </programlisting> |