3bet vs Isolation Raiser

[js2002]

Hi,

how do I make this stat:

3bet vs Opponent who isolation-raised 1 or more limpers?

[kraada]

The 3bet portion works just the same - and you can make sure there's a limper by making certain that the first position in the actors string (cash_hand_summary.str_actors_p) is different than the first position in the aggressors string (cash_hand_summary.str_aggressors_p) - if they are different, there must have been a limp.

[js2002]

The 3bet portion works just the same - and you can make sure there's a limper by making certain that the first position in the actors string (cash_hand_summary.str_actors_p) is different than the first position in the aggressors string (cash_hand_summary.str_aggressors_p) - if they are different, there must have been a limp.

AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int != substring(cash_hand_summary.str_actors_p from 1 for 1)::int

this term correct?

So this is my denumerator

sum(if[cash_hand_player_statistics.flg_p_3bet_opp AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int != substring(cash_hand_summary.str_actors_p from 1 for 1)::int, 1, 0])

for "3bet vs Isoraiser"

[js2002]

I adapted it for 4bet:

sum(if[cash_hand_player_statistics.flg_p_4bet AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int != substring(cash_hand_summary.str_actors_p from 1 for 1)::int, 1, 0])

hope this wont lead to errors because of the aggressor string

[kraada]

I should also mention you also want to add a check to make sure the aggressor string is long enough otherwise bad things can happen.

Adding: char_length(cash_hand_summary.str_aggressors_p) >= 2

will be sufficient since that's all you need for these stats (one aggressor implies one actor so you're fine there).

[js2002]

posted the stat to rep already.

what bad things happen? only a NA display or sth?

[kraada]

The query might fail giving no data - it's worth editing it in.

[js2002]

did it, please report that to the warehouse (team)

Q: I dont understand why the term added before the expression secure the "command"?
x AND (y >=2) AND (z != a)
leads to a request for all 3 terms. the >=2 term has no if before it, so the (z != a) will perform anyways.

[kraada]

It's because of the order in which PostgreSQL interprets things - if the string is empty or too short it will return an error when trying to convert it to a numeric, but if you test the size the size test will be run first and when it fails the string comparison won't be done.

[Npyu_system]

Hello !

Any chance that this custom stats becomes available for tournament hands ?

I would do it my self but I have absolutely no idea how to convert it.

Thank you !