We Heart Code

Most of us have written little mass e-mailing scripts in the past. No big deal, connect to SNMP, loop through our subscriber list, do our thang. But then the requirements come in: “
“Hey, I need to know what person is clicking on that link, and what time they opened it.”
“How does it look in a […]

Bookmark to:

Postgres seriously kicks ass, here's a quick way to do a substring based on a regular expression. A Co-worker wanted to get the first word out of a column that contained a sentence. If we were using something lame like oracle we'd have to do gymnastics to do that.
It's a one-liner in postgres.

SELECT substring('this is [...]

Bookmark to: