How to change type from array to primitive in PostgreSQL? -


i'm trying change column type integer[] integer. table has no row in , i've dropped default.

alter table user alter column book_ids type integer using book_ids::integer; error:  cannot cast type integer[] integer 

i found how change type integer integer[] not other way around.

arr[1] first element of arr.

alter table user alter column book_ids type integer using book_ids[1]; 

Comments

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

php - How can i create a user dashboard -

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -