Re: the same time value return different values,is it a problem - Mailing list pgsql-bugs

From 姜梦洋
Subject Re: the same time value return different values,is it a problem
Date
Msg-id 33B6EA55-67C0-48DA-B87D-6DE1A0CD9377@icloud.com
Whole thread Raw
In response to the same time value return different values,is it a problem  (姜梦洋 <minesunny@icloud.com>)
List pgsql-bugs
sorry for images,here are clear;


On Sep 13, 2023, at 3:24 PM, 姜梦洋 <minesunny@icloud.com> wrote:

I find the time type accuracy of the database. Using PreparedStatement, the accuracy found out for the sixth time is different from the first five times. This number is exactly the same as the threshold of the PreparedStatement. I can understand that the database can optimize PreparedStatements and reduce repeated parsing and other unnecessary operations. but I don’t quite understand how such processing will affect the execution results(Or maybe I don’t have a deep understanding of PreparedStatement.). now I run the code and get some results
<1.jpeg><2.jpeg><3.jpeg><4.jpeg><5.jpeg>

Attachment

pgsql-bugs by date:

Previous
From: 姜梦洋
Date:
Subject: the same time value return different values,is it a problem
Next
From: Amit Kapila
Date:
Subject: Re: [16] ALTER SUBSCRIPTION ... SET (run_as_owner = ...) is a no-op