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 | ...

On 25th of February, Tom Lane committed patch: Support data-modifying commands (INSERT/UPDATE/DELETE) in WITH.   This patch implements data-modifying WITH queries according to the semantics that the updates all happen ...

My jabber server had the feature, that it logs all messages that got sent through it. This is pretty cool, and useful. And now, i got asked to use it to create list of conversations. What exactly is this? Whenever I send ...

One database that I am monitoring uses a lot of stored procedures. Some of them are fast, some of them are not so fast. I thought - is there a sensible way to diagnose which part of stored procedure take ...

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 ...