PostgreSQL tip

1. extract number from string  :input:  select substring (column_name from ‘[0-9]+’) as new_column_name  from table..
2. create table : int null  null represents that the entry can be null if missing data