Anthony Nowocien · @nthony
78 followers · 127 posts · Server fosstodon.orgMy query of the day:
SELECT col1,col2,col2
FROM t
WHERE upper(col500) IN (upper('XXX'), upper('YYY'), ...)
with the slight twists being that :
- col500 contains an integer value and so does XXX, YYY
-the IN clause contains over 100 000 elements.
#postgresql #sql #dbaslife #theweekendiscoming
Wayward Son ⚡:verified: · @waywardSon
82 followers · 244 posts · Server metalhead.club
It's #bandshirtfriday again!
Today's choice is Dream Troll's "Skull Chrome Viper" t-shirt.
#DreamTroll #SkullChromeViper #HeavyMetal #Bandshirt #Friday #TheWeekendIsComing #tshirt
#tshirt #theweekendiscoming #friday #bandshirt #heavymetal #skullchromeviper #dreamtroll #bandshirtfriday