I sure want to make a Google+ profile just to send you a message.
Do you need to? I mean, it's right there in GMail, and pretty much everyone who has an Android phone has a Google account anyway.
Be good and I may grant you my
@boomzilla I'm pretty sure you can actually set them on actual user-defined functions as well, but I can't find the docs for it for the life of me right now, and I'm not sure what limitations (if any) are set on your functions when doing so, so I didn't want to mention it without being able to back it up.
@raceprouk not being a great scholar of US geography, I assumed that the location in the latest tweet is close to the location of whatever happened in TFA?
Dunno, and I'm honestly too lazy to check.
@timebandit I've made the link well enough, thank you. But please, don't let me get in the way of you judging a company for picking a headline weeks before a tragic event.
I agree, people are getting too damned critical of companies not reacting within 17 milliseconds from something happening.
News flash: I also hear of important news hours later many times. Because I'm at work. And people who post this stuff are at work as well. And maybe, just maybe, they don't have the time to check all the news outlets before every tweet because there's a 0.000000001% chance something happened at or near the location they are posting about or use some word that's not acceptable as of 14 minutes ago because shit hit the fan somewhere.
Or, you know, it might also be a bot posting this stuff.
It's not a horrible application to connect to multiple chat networks... well, it wasn't, until most of them died and only bits of XMPP standard (such as it is) are still being used by Google and Facebook, so now it's a bit crippled even there.
It was pretty good for ICQ, MSN and the like back in the day at least. But its IRC support was always pretty shit.
Doesn't matter much, as every modern client now has the capability to break it up on the way out the door anyway.
Except for Pidgin, which some people I know keep on insisting on using.
ETA: It also shows the entire message on your end so if it got cut, you don't know where it got cut, so any large copypasta is then followed by someone else repeating the last fragment so the person knows where it got cut and can re-send it... it's highly annoying.
Does anyone know if there's a way to tell Postgres to index something like
rank() over (partition by foo order by bar asc)?
Yes, you can create indexes on expressions:
@ben_lubar I must say I'm not sure of the exact method and terminology off the tip of my head. Would have to look into it.
On the other hand, why don't you explain what exactly you're trying to do and what the bottleneck is, maybe there's a better method than what you're trying to do.
Looks like your connection to What the Daily WTF? was lost, please wait while we try to reconnect.