SQL Error: ERROR: column cannot be cast automatically to type integer HINT: You might need to specify "USING broj ugovora::integer". code example

Example: Datatype mismatch: 7 ERROR: column cannot be cast automatically to type integer

alter table a.attend alter column terminal TYPE INTEGER  USING (terminal::integer) ;