Column medicare.admissions.zip4

Overview of column zip4 in table medicare.admissions

Table	medicare.admissions
Qualified name	medicare.admissions.zip4
Datatype	INT
Column type	copied

Expressions

SELECT zip

Casts:

Original type	Cast expression
numeric	(CASE WHEN {column_name} < 100000 THEN NULL ELSE ({column_name}%10000)::INT END)
character varying	(CASE WHEN LENGTH({column_name}) < 6 THEN NULL ELSE SUBSTRING({column_name} FROM 6 FOR 4)::INT END)