Re: Getting "ERROR: upper bound of FOR loop cannot be null" when trying to use a stored proc in a check constraint def.

> On 17 Jul 2021, at 0:26, David Gauthier wrote: (…) > dvdb=# select validate_proj_csv('sabin,strix2,ipu1.0'); > validate_proj_csv > --- > 1 > (1 row) > > dvdb=# select validate_proj_csv('sabin,strix2,ipu1.00'); > NOTICE: Project "ipu1.00" in project csv "s

Re: Getting "ERROR: upper bound of FOR loop cannot be null" when trying to use a stored proc in a check constraint def.

On 7/17/21 10:13 AM, David Gauthier wrote: Please reply to list also. Ccing list. That was it.  I added...   if (proj_csv is null) then     return(1);   end if; ... and it works fine. Back in earlier versions of PG (I'm talking v8), existing column values weren't checked.  I remember you