Viewing profile — trinitry3

Only if your developers are inexperienced.

Did we just seriously compare coffee to meth?

You can use -P.

Nothing to do with CTEs. The queries were badly written to begin with and should have used LATERAL.

I have a recurring dream where my teeth are glued shut but for whatever reason I have to open my mouth, ripping all my teeth out.

She could just say that to every patient and she'd be right most of the time ;-)

> Why should any government incentivize that? Well maybe they shouldn't, but it's shitty to apply this kind of policy retroactively. (I don't know when they actually announced the …

This is really bad advice: 1) This is not really a temporary table in the traditional sense; you're creating a real table and then dropping it. This has problems with concurrency (…

> Relating to wallhacks, they can use your last 1,000 matches, and if you're never/rarely surprised by a camping enemy, you're probably cheating. Your camera position moments befor…

> Say I wanted to present a list of users with their top three to-do items, that's impossible using the above method. Not really: SELECT u.user, i.text FROM users u, LATERAL (SELEC…

There was a patch for fixing #1 with new syntax for the next version on the mailing list, so perhaps in a year this'll get fixed?