Re: Ordering of statistic views

2025-02-05 Thread Daniel Westermann (DWE)
>> I am wondering if there is a reason that the list on top of: >> https://www.postgresql.org/docs/devel/monitoring-stats.html >> >> ... is not alphabetically ordered? >This was cleaned up most recently in commit 72e0ff2677c. Please check >there if the current arrangement does not match the guida

Minor suggestions for docs regarding json_table

2025-02-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/functions-json.html Description: In https://www.postgresql.org/docs/current/functions-json.html#FUNCTIONS-SQLJSON-TABLE 1. There is unused `PASSING` argument `filter2` Consider: ```sql S

Re: timestamp with time zone ~> GMT

2025-02-05 Thread Jonathan Stanley
Thank you. I believe that explanation would have helped. FWIW, I ultimately decided to simply duplicate the column: 1. keep the timestamp column for sorting/filters/etc. 2. add a full iso 8601 column as text for straightforward client handling (avoids forcing the client to stitch the data back tog