Yes, it seems OK on a small sample (however it needs to be ridiculously small to be "quick"). But I'm interested in the average value of this over the whole database. Is it possible with PT4 to add a new row to lets say tourney_summary table in the database, by computing it through some qu...

max(case when tourney_hand_summary.id_hand = ( select tourney_hand_summary.id_hand from tourney_hand_summary as ths where ths.id_tourney = tourney_hand_summary.id_tourney and ths.cnt_players = 2 order by ths.date_played limit 1) then tourney_hand_player_statistics.amt_before else 0 end) I use date_...

Even no idea why it would be OK in the postgeresql console but not valid in PT4 ?

Hello all, I'm a little bit rusty when it comes to SQL stuff but I started building couple stats on PT4, however I'm now trying to get a "harder" one, and failing :/ So any help would be appreciated. I'd like to get the player stack size on the first hand of HU during a tournament (if head...

It was not a mistake that I posted in PT3 section

Hello guys, I'm currently playing DoN games, and I'd like to know things like : - what is the average shove range between 4 and 5 bb deep, from BTN, of all the vilains on which I have less than 400 hands on ? - what is the average calling range from BB between 8 and 10 bb deep, vs a shove from CO, o...