Archiwizowane October, 2012

I use VIM. For more or less everything. Including writing blogposts. Usually, when I was working on blogpost about PostgreSQL, I would write an sql file, switch to another console with psql running, run \i, get output, and then copy/paste the ...

Yesterday on irc someone asked: Hi, how do I get top 5 values from a column group by another column?? From further discussion, I learned that: total rows in table is 2 million. It'll have unique words of less than 1 million.. (approx ...