Hi Everyone,
I have an SQL that updates a table in our database. The SQL in question is:
UPDATE public.sum_partn_alloc AS T1 SET effective_date =
to_char(CURRENT_TIMESTAMP + interval '6 days', 'MMDDHH24MI') FROM
public.sum_main AS T2
WHERE T1.status != 8 AND (T1.effective_date = '0'
0771
edmund.j.man...@nasa.gov<mailto:edmund.j.man...@nasa.gov>
From: Martin Gainty
Date: Friday, April 18, 2025 at 11:51 AM
To: "Mansky, Edmund J. (GSFC-671.0)[ADNET Affiliate]"
, "pgsql-gene...@postgresql.org"
Subject: [EXTERNAL] Re: Why is an error not thrown w
