Re: Inconsistent information on default ordering for ORDER BY clause

2023-12-08 Thread David Rowley
On Fri, 8 Dec 2023 at 22:49, PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/16/sql-select.html > Description: > > At the top of the sql-select page it says > > "If ORDER BY is not given, the rows are returned in whatever order the > system finds fastest to produce." > > but la

Re: Monetary Data Types Improvement

2024-03-18 Thread David Rowley
On Tue, 19 Mar 2024 at 07:43, Erik Wienhold wrote: > Maybe add a note like: > > "Money does not implement all operators that one might expect of a > numeric type. For example, use (-amount::money::numeric)::money to > negate amount." > > That would also fit nicely with the existing examples on

Re: Need a PostgreSQL 16 developer edition for enabling vector support

2024-04-04 Thread David Rowley
On Thu, 4 Apr 2024 at 19:48, PG Doc comments form wrote: > We want to compile a vector extension in the postgres 16 dev edition and > use > the vector feature in the PostgreSQL You'll be better joining the pgsql-general [1] mailing list to ask this sort of question. The tool you've used is for r

Re: nchar is undocumented

2024-05-04 Thread David Rowley
On Sun, 5 May 2024 at 12:41, Erik Wienhold wrote: > So, I think we should either remove that one nchar instance (because it > doesn't add any real value) or document it properly. The attached patch > does the latter. It seems easier to do the former, that way we don't need to reconsider Peter's

Re: Missing examples for hash partitioning

2024-05-05 Thread David Rowley
On Sun, 5 May 2024 at 08:13, PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/16/ddl-partitioning.html > Description: > > There is no example showing the syntax of Hash Partitioning in this section > of the documentation, it's missing. There are examples of hash partitioning in

Re: Missing examples for hash partitioning

2024-05-05 Thread David Rowley
On Sun, 5 May 2024 at 19:27, David Rowley wrote: > There are examples of hash partitioning in [1]. Maybe we should add a > link so those can be more easily found. I see the link is already there, per: "See CREATE TABLE for more details on creating partitioned tables and partitio

Re: Minor accuracy issue

2024-06-05 Thread David Rowley
On Wed, 5 Jun 2024 at 20:23, PG Doc comments form wrote: > Under page "https://www.postgresql.org/docs/current/limits.html";, it is > mentioned: > > relation size - 32TB > rows per table - limited by the number of tuples that can fit onto > 4,294,967,295 pages > > > 32 TB is 35,184,372,088,832 byt

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-07-17 Thread David Rowley
On Thu, 18 Jul 2024 at 16:55, Muhammad Ikram wrote: > 5.1. Table Basics # > > when we hover over Table Basics, it shows # sign postfixed. I think it needs > to be removed Those are meant to be there. They allow you to copy a URL directly to that doc section. In [1], there was some talk about us

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-07-17 Thread David Rowley
On Thu, 18 Jul 2024 at 17:18, Tom Lane wrote: > Yeah. I've found this new feature useful multiple times already, > but the '#' icon is as non-mnemonic and unobvious as could possibly > be. OTOH, I don't know of a standard icon for this feature. I also find it useful and certainly don't want it

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-07-18 Thread David Rowley
On Thu, 18 Jul 2024 at 19:46, Daniel Gustafsson wrote: > There is a lot of variability though so > whichever we choose it will be wrong one for someone. I think the tooltip would help reduce the chances of someone being confused. For an example, see [1]. David [1] https://devblogs.microsoft.c

Re: wrong field in example

2024-07-24 Thread David Rowley
On Thu, 25 Jul 2024, 12:57 am David G. Johnston, wrote: > I think you mis-copied the query - the one on the page has “select x”, not > “select *”. > That text exists as it was quoted. What the report is lacking is an indication of what is wrong with the text. David >

Re: incorrect PostgreSQL documentation for pg_type

2024-08-02 Thread David Rowley
On Sat, 3 Aug 2024 at 02:54, PG Doc comments form wrote: > Table 51.63. pg_type Columns > NameTypeReferences > --- > typinputregproc pg_proc.oid > typoutput regproc pg_proc.oid > typreceive regproc pg_pr

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-08-11 Thread David Rowley
On Fri, 19 Jul 2024 at 06:03, Jonathan S. Katz wrote: > > On 7/18/24 1:59 PM, Daniel Gustafsson wrote: > > Looking a bit closer, the Python documentation does just this, a pilcrow > > with a > > tool-tip ("Link to this heading") when hovering over it > > I forgot why we went with the "#" and not

Re: Re: Supplements and suggestions and about postgresql sequence setval function in the documents

2024-08-21 Thread David Rowley
On Thu, 22 Aug 2024 at 11:41, yanliang lei wrote: > What I want to express is: >There is no description in the document that the schema name can be > included before the sequence name I'm not to sure there is any problem here. If you look at the final paragraph in: https://www.postgresql.org

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-10-16 Thread David Rowley
On Thu, 17 Oct 2024 at 11:19, Bruce Momjian wrote: > Where are we on this? I still see "#". I was hoping for some voting for or against my patch or the general idea of it. Also, my web skills in this area amount to trial and error, so it would also be good to have someone who knows what they're

Re: Limitation relates to memory allocation

2024-10-16 Thread David Rowley
On Mon, 14 Oct 2024 at 19:03, Ekaterina Kiryanova wrote: > Our research showed that the limit is imposed by the palloc() function, > regardless of whether it is a tuple or not, and if the data is > serialized or dumped, the effective limit can be even lower, typically > around 512MB per row. So fo

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-10-29 Thread David Rowley
On Thu, 17 Oct 2024 at 20:20, Daniel Gustafsson wrote: > My main concern is that the relative positioning will push it off screen with > a > break on smaller viewports (like phones). I can recreate what you sent in the screenshot, but I have to make my browser window as small as it will go and a

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-10-29 Thread David Rowley
On Wed, 30 Oct 2024 at 03:46, Daniel Gustafsson wrote: > On the whole I wonder if we shouldn't just go with the proposal since it > improves the status quo, optimizing for users who hover to get link anchors on > mobile probably isn't worth the investment in time. My primary motivation for hackin

Re: Tip box on Adding a Column

2024-11-01 Thread David Rowley
On Fri, 1 Nov 2024 at 22:06, Marcelo Fernandes wrote: > - > https://www.postgresql.org/docs/current/ddl-alter.html#DDL-ALTER-ADDING-A-COLUMN > > That says: > > > From PostgreSQL 11, adding a column with a constant default value no longer > > means that each row of the table needs to be updated wh

Re: No details on how to use Hash partitions: no example, no syntax

2024-09-18 Thread David Rowley
On Thu, 19 Sept 2024 at 02:17, Laurenz Albe wrote: > > On Tue, 2024-09-17 at 22:32 +, PG Doc comments form wrote: > > I would like the documentation to explain how to use Hash partitions. It > > says one needs to provide a modulus and remainder, but the exact syntax is > > not stated in the re

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-11-06 Thread David Rowley
On Thu, 7 Nov 2024 at 02:33, Daniel Gustafsson wrote: > Committed, and with some help from Magnus, the docs site has been reloaded > with > the new CSS. Everything seems to behave as expected when testing in Firefox, > Safari, Chrome and Edge. Great. Thank you to you both. David

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-11-06 Thread David Rowley
On Thu, 7 Nov 2024 at 03:58, Daniel Gustafsson wrote: > > > On 6 Nov 2024, at 15:51, Alvaro Herrera wrote: > > Ah, but we kept the #? I thought it was going to be changed to ¶ ... > > was there any voice against that? > > You're right, I mistakenly remembered there being no concensus and didn't

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-11-05 Thread David Rowley
On Wed, 30 Oct 2024 at 11:39, Daniel Gustafsson wrote: > > > On 29 Oct 2024, at 23:36, David Rowley wrote: > > Do you have access to make this change? I think it needs to go into > > https://www.postgresql.org/media/css/main.css > > I have a pgweb commitbit so if yo