Re: Incorrect/confusing information about timetz

2023-09-26 Thread Bruce Momjian
On Thu, Sep 7, 2023 at 05:00:59PM -0400, Bruce Momjian wrote: > On Thu, Sep 7, 2023 at 04:41:48PM -0400, Tom Lane wrote: > > Bruce Momjian writes: > > > Uh, yes to the storage part, no to the output part. ;-) Postgres does > > > store the timetz time zone offset, but it doesn't adust it once i

Re: group by can use alias from select list

2023-09-26 Thread Bruce Momjian
On Thu, Sep 7, 2023 at 10:11:00AM -0400, Bruce Momjian wrote: > We do farther down the docs in the GROUP BY section: > > https://www.postgresql.org/docs/devel/sql-select.html > > GROUP BY will condense into a single row all selected rows that share > the same values for the gro

Re: pg_upgrade doc uses inconsistent versions within the doc.

2023-09-26 Thread Bruce Momjian
On Tue, Sep 26, 2023 at 10:56:27AM -0700, David G. Johnston wrote: > On Tue, Sep 26, 2023 at 10:35 AM Bruce Momjian wrote: > > On Mon, Sep 18, 2023 at 08:14:04PM +, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page

Re: correct documentation in set role

2023-09-26 Thread Bruce Momjian
On Tue, Sep 26, 2023 at 11:44:42AM -0400, Bruce Momjian wrote: > On Mon, Sep 25, 2023 at 07:46:18AM +, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/16/sql-set-role.html > > Description: > > >

Re: pg_upgrade doc uses inconsistent versions within the doc.

2023-09-26 Thread David G. Johnston
On Tue, Sep 26, 2023 at 10:35 AM Bruce Momjian wrote: > On Mon, Sep 18, 2023 at 08:14:04PM +, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/16/pgupgrade.html > > Description: > > > > I feel lik

Re: pg_upgrade doc uses inconsistent versions within the doc.

2023-09-26 Thread Bruce Momjian
On Mon, Sep 18, 2023 at 08:14:04PM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/16/pgupgrade.html > Description: > > I feel like for readability the pg_upgrade doc should use the same > old_versi

Re: JSON type unsupported

2023-09-26 Thread Tom Lane
Vik Fearing writes: > Thank you for pointing this out. Peter's blog is slightly misleading in > that we do have the JSON data type, but the T801 feature is far from > complete. > For example, we do not have the JSON_SERIALIZE(), JSON()[1], > JSON_SCALAR() functions. We don't have the IS JSON

Re: correct documentation in set role

2023-09-26 Thread Bruce Momjian
On Mon, Sep 25, 2023 at 07:46:18AM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/16/sql-set-role.html > Description: > > it is good to mention that: > The specified role_name must be a role that

Re: JSON type unsupported

2023-09-26 Thread Vik Fearing
On 9/26/23 11:33, Erki Eessaar wrote: Hello According to Appendix D. SQL Conformance https://www.postgresql.org/docs/current/unsupported-features-sql-standard.html the feature T801 JSON data type is unsupported. However, PostgreSQL has data types JSON and JSONB. Here (http://peter.eisentraut

JSON type unsupported

2023-09-26 Thread Erki Eessaar
Hello According to Appendix D. SQL Conformance https://www.postgresql.org/docs/current/unsupported-features-sql-standard.html the feature T801 JSON data type is unsupported. However, PostgreSQL has data types JSON and JSONB. Here (http://peter.eisentraut.org/blog/2023/04/18/postgresql-and-sql-