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 1pVFoP-00080G-6W
	for pgsql-hackers@arkaria.postgresql.org; Thu, 23 Feb 2023 17:55:21 +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 1pVFoN-0003dg-W5
	for pgsql-hackers@arkaria.postgresql.org; Thu, 23 Feb 2023 17:55:19 +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 <samokhvalov@gmail.com>)
	id 1pVFoN-0003dX-LH
	for pgsql-hackers@lists.postgresql.org; Thu, 23 Feb 2023 17:55:19 +0000
Received: from mail-ed1-x52d.google.com ([2a00:1450:4864:20::52d])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <samokhvalov@gmail.com>)
	id 1pVFoL-0004BH-7b
	for pgsql-hackers@lists.postgresql.org; Thu, 23 Feb 2023 17:55:19 +0000
Received: by mail-ed1-x52d.google.com with SMTP id da10so46408976edb.3
        for <pgsql-hackers@lists.postgresql.org>; Thu, 23 Feb 2023 09:55:16 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20210112;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=qJPnAi21TwDR2PJx/r+P4U3MrshBhoEtxT9YCgQ0Ybo=;
        b=ClA1q0t86t9XV9JjuhZnxsf8BMw5nT88+Qkid+wOkC/uMRllZA/Vdh/JHyQSi2qnIH
         0xZvSIjxKpfZcyjlkQrWAHcRiENDmEPvrW/p8YjL7cpxKbHT/VRLheqZo7jxoikzLfgX
         cTMhV3E7kee29gB5O32ygJgJ7zcyIwl+TlHc8kC6L/flGh3MIAgNE5yOfPLZg4rsEA6z
         +mojrUzp1mbFLEpx4d5oNSMDzjNijexPsE1Dk6SxmBXTFnN9iIopmTBYEhL5ujA7pJ0C
         H9+BzTy7UtRo7ZJuTElKuDh0g5fU+c1+Ylmqqrq/CpfHCWPsUVWy59GuFFQr+dCxyya1
         lG3w==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20210112;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=qJPnAi21TwDR2PJx/r+P4U3MrshBhoEtxT9YCgQ0Ybo=;
        b=ZJrL5TaZ+bN0u5VTUfojYh7kUqo4K9jtBlZXcmqijt9iQJEGGl4gGKfy23r3RDYJSw
         nH8Kcwf196aVq2gzz6jPo5n/JNE2Kg4jL8WHt6BfXUuGFcAFOQXEybAEZhej77sz8yol
         ePNq3CqOOuuvsJV5u0XfXURA4pxlMMmXH8lcizIn8iwrhiKfCwq4OoyyFCkmIOIIlNIn
         IGcKNjMNbPkDCC1Ix8ABu5SJc434I1zKH9BcVPzQWaIRObqZkum74BTxnjeM3HZrAZmR
         ECQTMitIWcMBmP06XrTiHJcJHGhopDOnyLFamKvFUWwLam7jBYvaQgZCQilVLYH4IKNu
         wKTA==
X-Gm-Message-State: AO0yUKWO9IJ936uJIWUlISKBEpEbweYYle7ic4d/b+FUzosCAGT7CCIJ
	Ma8uamSBzNE9kM0ToeftpV7cplcqG8tj5CT2YUI=
X-Google-Smtp-Source: AK7set8KZDO0Ztoyt2hRwxqdha5Y2zeeRmpTBIKYQcN1Pkx17BaflrRrm8Htxo0UNPM7ryi4RzmTd30kGes8EhOCy4M=
X-Received: by 2002:a50:9f28:0:b0:4ad:7ba3:5bce with SMTP id
 b37-20020a509f28000000b004ad7ba35bcemr5742371edf.7.1677174914315; Thu, 23 Feb
 2023 09:55:14 -0800 (PST)
MIME-Version: 1.0
References: <CACLU5mSRwHr_8z=enMj-nXF1tmC7+Jn5heZQNiKuLyxYUtL2fg@mail.gmail.com>
 <157609.1677088525@sss.pgh.pa.us> <CANNMO+KqqM0YpVUmVDec+9nku9ai9T=Y5Tp=pZ0rp1jR3d8kqA@mail.gmail.com>
 <f4013949-746d-23e7-118d-6a7e9fa70c37@iki.fi> <2f1c8cb9-6f4d-2a03-d069-c4f9c2b574ab@enterprisedb.com>
 <e0320ffa-97ac-5976-ea76-2b9e87dd054c@iki.fi> <414445.1677163935@sss.pgh.pa.us>
 <CAOtHd0D28EgtwVKw+AUeEiH9Ai+-vUZH=PtCePBgpDp0WBY93Q@mail.gmail.com>
In-Reply-To: <CAOtHd0D28EgtwVKw+AUeEiH9Ai+-vUZH=PtCePBgpDp0WBY93Q@mail.gmail.com>
From: Nikolay Samokhvalov <samokhvalov@gmail.com>
Date: Thu, 23 Feb 2023 09:55:02 -0800
Message-ID: <CANNMO++GPeo3v7DELX02stRqWcJGdAbkh3i04m5Vc5nC3kkHng@mail.gmail.com>
Subject: Re: Proposal: %T Prompt parameter for psql for current time (like
 Oracle has)
To: Maciek Sakrejda <m.sakrejda@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Heikki Linnakangas <hlinnaka@iki.fi>, 
	Peter Eisentraut <peter.eisentraut@enterprisedb.com>, Kirk Wolak <wolakk@gmail.com>, 
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, 
	Pavel Stehule <pavel.stehule@gmail.com>, amborodin86@gmail.com, 
	Laurenz Albe <laurenz.albe@cybertec.at>
Content-Type: multipart/alternative; boundary="000000000000fe7c7805f561b660"
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/CANNMO%2B%2BGPeo3v7DELX02stRqWcJGdAbkh3i04m5Vc5nC3kkHng%40mail.gmail.com>
Precedence: bulk

--000000000000fe7c7805f561b660
Content-Type: text/plain; charset="UTF-8"

On Thu, Feb 23, 2023 at 9:05 AM Maciek Sakrejda <m.sakrejda@gmail.com>
wrote:

> I think Heikki's solution is probably more practical since (1) ..


Note that these ideas target two *different* problems:
- what was the duration of the last query
- when was the last query executed

So, having both solved would be ideal.

--000000000000fe7c7805f561b660
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Feb 23, 2023 at 9:05 AM Maciek Sa=
krejda &lt;<a href=3D"mailto:m.sakrejda@gmail.com" target=3D"_blank">m.sakr=
ejda@gmail.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquo=
te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px =
solid rgb(204,204,204);padding-left:1ex">
I think Heikki&#39;s solution is probably more practical since (1) ..</bloc=
kquote><div><br></div><div>Note that these ideas target two *different* pro=
blems:</div><div>- what was the duration of the last query</div><div>- when=
 was the last query executed</div><div><br></div><div>So, having both solve=
d would be ideal.</div></div></div>

--000000000000fe7c7805f561b660--