Postgres array - how to insert and ignore duplicate?

Question

I have a text array that's storing unique file urls. Is there a way to insert a url and ignore duplicate?

Mike Organek · Accepted Answer · 2020-09-14 21:16:57Z

1

Storing URLs that you want to be unique in a text[] array is a really bad idea, but since you asked.

update my_table
   set file_urls = file_urls||'new_file_url_here'
 where id = <id>
   and not 'new_file_url_here' = any(file_urls)

answered Sep 14, 2020 at 21:16

Mike Organek

12.6k3 gold badges15 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks! Yes I know :(