I got asked on irc to show some examples how to use recursive CTE. Apparently my previous post wasn't good enough :) I think that most of the users will use recursive cte to deal with trees I decided to show ...

Today, on Stack Overflow there was interesting question. Generally, given table that looks like this: room | people | price | hotel 1 | 1 | 200 | ...

Yesterday on my favorite IRC channel fooqux asked interesting question. I took some more questions, and here is problem description: We have a system which, every 5 minutes, takes a number of tasks to be done. Tasks are uniform. Within 5 ...

On 4th of September Tom Lane committed another great patch. This one is very large, and even after applying - it's has some rough edges. There will be need for additional patches to make the functionality fully robust, but the ...