Skip to content
Search Create account

DEV Community

DEV Community is a community of 603,512 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

Create new account Log in
loading...

Discussion on: Manipulating arrays with PostgreSQL

View post Full discussion
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"}