if anyone has experience using UDT (User Defined Types), I would like to understand how backward compatibility will work.
Say I have the following UDT
CREATE TYPE addr ( street1 text, zip text, state text );
If I modify the UDT "addr" to have a few more attributes (for example, zip_code2 int and name text):
CREATE TYPE addr ( street1 text, zip text, state text, zip_code2 int, name text );
How do older strings that have these attributes work? Is it even compatible?
thanks
source share