What is the definition of your Open Limp stat?

Are those Hyper KO's one table?

I'm running PostgreSQL 9.6 for over a year now and didn't experience any problems. But I'm not a hardcore grinder, I'm a just nerd who likes to play now and then

Anyway, if I do find something weird with the 10 version, I'll let you know via a support ticket.

@Flag_Hippo: Can you tell us the issues? I've been running PT4 with PostgreSQL 10 for almost a day now and it looks ok.

Good to hear

By the way, there is also a substr(string, from, length) function that can be used in a stat expression. So you don't need to create ten different columns for what you want to achieve.

If you do not use a separator character you got it right, else it would be:

Last action: 01, 02)
Second to last: 04, 02)
etc.

Everything WhiteRider said plus this

Code: Select all

ORDER BY tourney_hand_player_statistics.date_played DESC)

means the last action is at the most left position of the string, so second to last is the one next to it.

*Disclaimer: The following answer is by heart :) The ,01 ,20) in your code means it returns the first twenty characters of the recorded actions. But because for instance ISO has three characters and X has one, you don't know how many actions there will be in the string. If you make the individual ac...

Column amt_start_stack_won. tourney_hand_player_statistics.amt_won / amt_start_stack Column amt_start_stack. select distinct first_value(thps.amt_before) over (partition by thps.id_tourney order by thps.date_played) from tourney_hand_player_statistics as thps join tourney_summary as ts on ts.id_tou...

No problem. I do have a Starting Stack Won stat for a Hand report if that has any use for you.