From 5ea6c9d79882815d4cc1c3c302f415eb637466f2 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 28 Aug 2012 12:17:11 -0400 Subject: [PATCH] Update doc mention of how to compute bigint advisory lock value, per Tom Lane's correction. --- doc/src/sgml/catalogs.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index bf568f1811..3bcd82cbdd 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -7413,8 +7413,8 @@ high-order half in the classid column, its low-order half in the objid column, and objsubid equal to 1. The original bigint value can be reassembled with the - expression (classid::int::bit(64) << 32 | - objid::int::bit(64))::bigint. Integer keys are displayed with the + expression (classid::bigint << 32) | + objid::bigint. Integer keys are displayed with the first key in the classid column, the second key in the objid column, and objsubid equal to 2. The actual meaning of -- 2.40.0