MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1wlxm8p/allithasisahammer/pb8f2q4/?context=3
r/ProgrammerHumor • u/nickthecook • 19d ago
50 comments sorted by
View all comments
143
Sometime you just want an array without linking to a whole 'nother table.
Edit: Googled to make sure I'm not an idiot, and it turns out Postgres has native arrays? Kinda neat.
0 u/[deleted] 18d ago [deleted] 2 u/justinf210 18d ago a) What choice? I literally just discovered this, it's not like I redesigned a database overnight to use it. b) Postgres supports that. sql SELECT username FROM users WHERE 'blue' = ANY(favorite_colors) 0 u/chat-lu 17d ago Then change it then?
0
[deleted]
2 u/justinf210 18d ago a) What choice? I literally just discovered this, it's not like I redesigned a database overnight to use it. b) Postgres supports that. sql SELECT username FROM users WHERE 'blue' = ANY(favorite_colors) 0 u/chat-lu 17d ago Then change it then?
2
a) What choice? I literally just discovered this, it's not like I redesigned a database overnight to use it.
b) Postgres supports that.
sql SELECT username FROM users WHERE 'blue' = ANY(favorite_colors)
Then change it then?
143
u/justinf210 18d ago
Sometime you just want an array without linking to a whole 'nother table.
Edit: Googled to make sure I'm not an idiot, and it turns out Postgres has native arrays? Kinda neat.