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

From 姜梦洋
Subject the same time value return different values,is it a problem
Date
Msg-id 9831C223-91ED-43FC-8223-B90C46BA77C4@icloud.com
Whole thread Raw
Responses Re: the same time value return different values,is it a problem
Re: the same time value return different values,is it a problem
List pgsql-bugs

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.jpeg2.jpeg3.jpeg4.jpeg5.jpeg

Attachment

pgsql-bugs by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [16+] subscription can end up in inconsistent state
Next
From: 姜梦洋
Date:
Subject: Re: the same time value return different values,is it a problem