> 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