the same time value return different values,is it a problem

Поиск
Список
Период
Сортировка
От 姜梦洋
Тема the same time value return different values,is it a problem
Дата
Msg-id 9831C223-91ED-43FC-8223-B90C46BA77C4@icloud.com
обсуждение исходный текст
Ответы Re: the same time value return different values,is it a problem  (姜梦洋 <minesunny@icloud.com>)
Re: the same time value return different values,is it a problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: [16+] subscription can end up in inconsistent state
Следующее
От: 姜梦洋
Дата:
Сообщение: Re: the same time value return different values,is it a problem