On 2011-11-07 01:48, Tonkuma wrote:
As it turned out we decided to move the logic for this to the
application layer, but it is always interesting to see your solutions.

I cant help feeling that it would be nice to either:

a) use a cte in using part of a merge statement
b) extend row/range in window clause with a result restriction

It would make it easy to handle "napsack" problems. Anyhow thanks for
your solutions, much appreciated


/Lennart

[...]