williamI am trying to add/change a constraint programmatically, but not if it
already exists, and is the same as before.
I can so something like (may not be precise ...)
select check_clause from information_schema.check_constraints where
constraint_name = 'my-name'
but this returns that clause in a normalised format that is not compatible
with the text I am trying to compare, so I'm adding something like ...
alter table my_table add check (my_type = any (array['GOOD' , 'BAD']))
but the check_clause from above looks like ...
(((my_type)::text = ANY (ARRAY['GOOD'::text, 'BAD'::text])))
Is there a way of getting the "normalised" version of constraint so decide if
I need to update the constraint if one already exists?
Steve