Re: BUG #14322: Possible inconsistent behavior with timestamp_to_str()
От | Keith Fiske |
---|---|
Тема | Re: BUG #14322: Possible inconsistent behavior with timestamp_to_str() |
Дата | |
Msg-id | CAG1_KcA-RuEWO6BmmfXVGLj66ig437Cj2c8nc0UpwrhEL5PxHQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: BUG #14322: Possible inconsistent behavior with timestamp_to_str() (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: BUG #14322: Possible inconsistent behavior with
timestamp_to_str()
|
Список | pgsql-bugs |
On Tue, Sep 13, 2016 at 4:52 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > Keith Fiske <keith@omniti.com> writes: > > Ok, this may be more of an actual issue than I thought. It seems that, > even > > if all variables to the timestamptz_to_str() function have a valid value > > set, if it is called multiple times in the same statement, it keeps the > > first value for all following occurrences. > > What is current_partition_timestamp? Is it coming from the transaction > timestamp? That doesn't change intra-statement ... > > regards, tom lane > No, it's obtained elsewhere by querying the current max timestamp value from the partition set. Shouldn't matter if it was, though. You can see that all it takes to change the string output of the timestamp is swapping the values around. The values of the variables are the same in either case.
В списке pgsql-bugs по дате отправления: