Minor difference in behavior between +/- - Mailing list pgsql-bugs

From Ryan Murphy
Subject Minor difference in behavior between +/-
Date
Msg-id CAATxnCxffW3w8oV3zCZg8jcvL=KAhewVV0gk2x0CSfDVy5FDLw@mail.gmail.com
Whole thread Raw
Responses Re: Minor difference in behavior between +/-  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
SELECT NULL - date '2023-01-05';
-> result is null
SELECT NULL + date '2023-01-05';
-> result is [42725] ERROR: operator is not unique: unknown + date Hint: Could not choose a best candidate operator. You might need to add explicit type casts. Position: 13

I would expect both of those to be null.

Thanks,
Ryan

pgsql-bugs by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [OT] Microsoft: Kubernetes clusters hacked in malware campaign via PostgreSQL
Next
From: PG Bug reporting form
Date:
Subject: BUG #17759: MERGE UPDATE statements do not cause generated columns to update