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
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
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
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
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
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
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
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
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.