DEV Community

loading...

Discussion on: Manipulating arrays with PostgreSQL

Collapse
gevera profile image
Denis Donici

thanks for sharing. Good stuff

How would I go about creating a unique set out a query like this

select tags from blog.posts;

 tags          
------------------------
 {mind}
 {thoughts,energy,mind}
 {postgres,"data base"}
(3 rows)

Enter fullscreen mode Exit fullscreen mode

the expected result would be {thoughts,energy,mind, postgres,"data base"}