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: Monetary Data Types Improvement

2024-03-18 Thread Erik Wienhold
I wrote: > The attached patch does that. Hit send to early. -- Erik >From 281e684b242314d93120faf875c1456ecdddef2b Mon Sep 17 00:00:00 2001 From: Erik Wienhold Date: Mon, 18 Mar 2024 19:38:53 +0100 Subject: [PATCH v1] Add note about missing money operators --- doc/src/sgml/datatype.sgml | 10

Re: Monetary Data Types Improvement

2024-03-18 Thread Erik Wienhold
On 2024-03-17 03:16 +0100, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/datatype-money.html > Description: > > It's not explicitly obvious that money doesn't behave like a normal numeric > type in

Monetary Data Types Improvement

2024-03-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/datatype-money.html Description: It's not explicitly obvious that money doesn't behave like a normal numeric type in that executing a procedure with a negative numeric value for money

Re: Duplicates being removed from intarray on subtraction of another intarray

2024-03-18 Thread Erik Wienhold
On 2024-03-18 09:21 +0100, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/16/intarray.html > Description: > > Hi, > I recently ran into an unusual issue with the intarray extension where if > you

Re: Duplicates being removed from intarray on subtraction of another intarray

2024-03-18 Thread Laurenz Albe
On Mon, 2024-03-18 at 08:21 +, PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/16/intarray.html > > Hi, > I recently ran into an unusual issue with the intarray extension where if > you subtract one array from another the result is *also* sorted and > de-duplicated. The

Re: Discourage splitting pg_wal directory

2024-03-18 Thread Laurenz Albe
On Mon, 2024-03-18 at 11:32 -0400, Greg Sabino Mullane wrote: > "It is advantageous if the WAL is located on a different disk from the > main database files. This can be achieved by moving the pg_wal directory > to another location (while the server is shut down, of course) and > creating a

Discourage splitting pg_wal directory

2024-03-18 Thread Greg Sabino Mullane
Someone pointed out this morning that we still have this in our docs: "It is advantageous if the WAL is located on a different disk from the main database files. This can be achieved by moving the pg_wal directory to another location (while the server is shut down, of course) and creating a

Duplicates being removed from intarray on subtraction of another intarray

2024-03-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/intarray.html Description: Hi, I recently ran into an unusual issue with the intarray extension where if you subtract one array from another the result is *also* sorted and de-duplicated.