Read through all values in an array in PostgreSQL

Same applies to Greenplum:

select col1,array1 from schema.table WHERE 'value_to_search_for'= ANY(array1);

array1 is a column in the table with type name[] in this case

Comments

Post a Comment

Popular posts from this blog

rsync to SD card recopying files

I was trying to rsync some iTunes music to an SD card from my Mac. All was working well but all the files were being synced each time. Turns out it's an issue with a Microsoft(FAT32) formatted card, which my Samsung Intercept has. Answer was to add --modify-window=1 as an rsync option. Solution here .
Read more

OS X right side of menu bar frozen

I am having a problem with my Mac where the right side of the menu bar will freeze when I run VMware. The problem is that my clock freezes and I lose track of time. While this isn't a solution for the overall problem, I found a fix that allows me to reset the menu bar and get my clock back on track. Simply run the following command in a Terminal: killall SystemUIServer
Read more

Changing the email address on your Nike + iPod acount

These directions worked on a Mac running 10.5.8. I recently changed the email address on my Nike+ account. Getting to sync properly with iTunes again was a tad challenging. I basically followed the steps here but I did not reset my iPod. I lost a few runs because I didn't do things in the proper order. 1. Uncheck the automatically send workout data to nikeplus.com in the Nike + iPod tab in iTunes and sync your iPod (in iTunes) without new workouts on your iPod. 2. Get a new workout recorded on your iPod. It can simply be walking around for 5 or 10 seconds. 3. Log in to Nike+ using Safari. 4. Connect your iPod with an unsynced run/walk 5. Recheck the automatically send workout data to nikeplus.com in the Nike + iPod in iTunes and click Apply. Your new Login ID is hopefully now showing in iTunes.
Read more