Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1lbkU5-0003m3-59
	for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Apr 2021 13:44:09 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1lbkU3-0005x4-6J
	for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Apr 2021 13:44:07 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1lbkU2-0005wx-Vj
	for pgsql-hackers@lists.postgresql.org; Wed, 28 Apr 2021 13:44:06 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1lbkU0-0004cw-Mi
	for pgsql-hackers@postgresql.org; Wed, 28 Apr 2021 13:44:06 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 13SDhwOE2794510;
	Wed, 28 Apr 2021 09:43:58 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Munro <thomas.munro@gmail.com>
cc: Peter Eisentraut <peter.eisentraut@enterprisedb.com>,
        David Steele <david@pgmasters.net>,
        Pavel Stehule <pavel.stehule@gmail.com>,
        Petr Fedorov <petr.fedorov@phystech.edu>,
        pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when
 extracting epoch
In-reply-to: 
 <CA+hUKGLcLH1k0tK9nRm=B-0jWKCfr2STS4bbqTYxGjNZgvXcRw@mail.gmail.com>
References: 
 <CA+hUKGK+K8NyS57tU841m1tSF6ha3W0udN2dw_Hbc=D_0OPbmA@mail.gmail.com>
 <ee683994-8f7c-aded-be43-543e66e68b94@2ndquadrant.com>
 <a3be61d9-f44b-7fce-3dc8-d700fdfb6f48@2ndquadrant.com>
 <CAFj8pRC8cgoiQMT235cky4Pa40gj=s0m3PftmaJLSt9MAiwj_Q@mail.gmail.com>
 <be30c07c-3f7b-7c86-f1c5-d0858046b26f@2ndquadrant.com>
 <1551357.1599435992@sss.pgh.pa.us>
 <097a4242-0748-98e3-06ab-ded1d366cd76@2ndquadrant.com>
 <1893468.1599658711@sss.pgh.pa.us>
 <38fc499a-ae52-efb6-aad6-82f812d6782d@2ndquadrant.com>
 <20200917055327.GU2873@paquier.xyz> <20200930071543.GL1996@paquier.xyz>
 <2fb99632-9302-6509-78ce-3aaed3fd7f40@2ndquadrant.com>
 <3ff4be02-1e2b-564f-9b53-3dc561da8218@pgmasters.net>
 <3013402.1615829712@sss.pgh.pa.us>
 <8fae8673-0d5b-12d9-7342-daed0d590594@2ndquadrant.com>
 <901bcfb8-36c8-27b2-b148-042392992eeb@2ndquadrant.com>
 <4158031.1616184417@sss.pgh.pa.us>
 <75db3efe-8023-58ef-9ee4-8a6a3101c7ca@2ndquadrant.com>
 <226163.1618847845@sss.pgh.pa.us> <1197050.1619123213@sss.pgh.pa.us>
 <2658907.1!
 619538982@sss.pgh.pa.us>
 <CA+hUKGLcLH1k0tK9nRm=B-0jWKCfr2STS4bbqTYxGjNZgvXcRw@mail.gmail.com>
Comments: In-reply-to Thomas Munro <thomas.munro@gmail.com>
	message dated "Wed, 28 Apr 2021 17:43:27 +1200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2794508.1619617438.1@sss.pgh.pa.us>
Date: Wed, 28 Apr 2021 09:43:58 -0400
Message-ID: <2794509.1619617438@sss.pgh.pa.us>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/2794509.1619617438%40sss.pgh.pa.us>
Precedence: bulk

Thomas Munro <thomas.munro@gmail.com> writes:
> On Wed, Apr 28, 2021 at 3:56 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Of course Wikipedia has been known to contain errors, but now
>> I'm inclined to think I blew this.  Anyone want to check my work?

> I tried a couple of examples not from Wikipedia.  ...

Thanks for checking!  I'll go adjust the documentation.

			regards, tom lane