I need something like flg_f_2bet_opp (but it doesn't exist)

[Info Shove]

I need to know how to say either that he faces an all-in bet or that the bettor's stack is equal or smaller than his bet. Is there any possibility in to express that in PT SQL?

[kraada]

Use cash_hand_player_statistics.enum_face_allin.

This character is set to the street on which the player faced an all-in. The character is in lowercase if the after a call the player could potentially lose more money to another player in the pot. The character is in uppercase if, after calling, the player could lose no more than the amount of the call. Possible values are: “P” Preflop without more potential losses beyond the call, “p” Preflop with more potential losses beyond the call, “F” Flop without more potential losses beyond the call, “f” Flop with more potential losses beyond the call, “T” Turn without more potential losses beyond the call, “t” Turn with more potential losses beyond the call, “R” River without more potential losses beyond the call, “r” River with more potential losses beyond the call, “N” Did not face an all-in.

[Info Shove]

Thanks. So as far as you can tell, do you think this will work correctly as a flop 2bet opportunity flag in any possible situation?

Code: Select all

cash_hand_player_statistics.amt_f_bet_facing > 0 AND cash_hand_player_statistics.amt_f_bet_facing < (cash_hand_player_statistics.amt_before - cash_hand_player_statistics.amt_bet_p) AND NOT cash_hand_player_statistics.enum_face_allin SIMILAR TO '%(f|F)%'

[kraada]

That will work, though easier is just:
cash_hand_player_statistics.enum_face_allin SIMILAR TO '(f|F)'

enum_face_allin is a single character and thus nothing can be before (or behind) the F (or f).

[Info Shove]

What character will enum_face_allin return if the player faces an all-in raise from the shortest stack preflop ('p') and an all-in bet from a different player on the flop?

[Info Shove]

I just read this:

[...] An uppercase letter means we would be (all-in) if we were to call (but the raiser might not be) [...]

That means I only need this part right?

Code: Select all

cash_hand_player_statistics.amt_f_bet_facing > 0 AND NOT cash_hand_player_statistics.enum_face_allin SIMILAR TO '(f|F)'

[kraada]

Yeah that should do it.

[Info Shove]

Thanks but what about this question?

What character will enum_face_allin return if the player faces an all-in raise from the shortest stack preflop ('p') and an all-in bet from a different player on the flop?

[kraada]

I think the last street controls the letter but I'll have to double check that to be 100% certain.

[Info Shove]

I think the last street controls the letter but I'll have to double check that to be 100% certain.

That would be bad for my 2bet opp flag as facing a second all-in on the turn or river would result in the flop all-in being ignored.

If I have a hand showing this exact scenario, how can I make PT display the character of enum_face_allin for the hand for testing purposes?