Document how to create advisory lock "bigint" values in SQL.

bmomjian · bmomjian · commit bf849af7f347 · 2012-08-27T22:36:48.000-04:00
David E. Wheeler
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
@@ -7412,7 +7412,10 @@
    A <type>bigint</type> key is displayed with its
    high-order half in the <structfield>classid</> column, its low-order half
    in the <structfield>objid</> column, and <structfield>objsubid</> equal
-   to 1.  Integer keys are displayed with the first key in the
+   to 1. The original <type>bigint</type> value can be reassembled with the
+   expression <literal>(classid::int::bit(64) &lt;&lt; 32 |
+   objid::int::bit(64))::bigint</literal>. Integer keys are displayed with the
+   first key in the
    <structfield>classid</> column, the second key in the <structfield>objid</>
    column, and <structfield>objsubid</> equal to 2.  The actual meaning of
    the keys is up to the user.  Advisory locks are local to each database,
