2015-12-14 23:15 GMT+01:00 Daniel Verite <dan...@manitou-mail.org>: > Pavel Stehule wrote: > > > > here is patch - supported syntax: \crosstabview VCol [+/-]HCol > [HOrderCol] > > > > Order column should to contains any numeric value. Values are sorted on > > client side > > If I understand correctly, I see a problem with HOrderCol. > > If the vertical header consists of, for example, a series of > event names, and it should be sorted by event date, then > the requirement of HOrderCol being strictly numeric is > problematic, in a way that the previous proposal was not, isn't it? >
I don't think - If you are able to do sort on server side, then you can use window functions and attach some numeric in correct order. But the situation is more simple probably - usually you are able to transform the field for order to number, so you don't need window functions - the transform function is enough. Regards Pavel > > Best regards, > -- > Daniel Vérité > PostgreSQL-powered mailer: http://www.manitou-mail.org > Twitter: @DanielVerite >
