WhiteRider wrote:If I understand correctly, you want to test for there being a bet and a call before the active player's first action?
For the turn that would be:
- Code: Select all
cash_hand_player_statistics.amt_t_bet_facing > 0 and char_length(cash_hand_summary.str_actors_t) >= 2 and substring(cash_hand_summary.str_actors_t from 1 for 1) ::int > cash_hand_player_statistics.position and substring(cash_hand_summary.str_actors_t from 2 for 1) ::int > cash_hand_player_statistics.position and
This says that the player faced a bet, there were at least 2 actions and both of the first two were by players who were out of position to the active player (because their position numbers are higher).
You'll need to add in any earlier street actions, and any subsequent turn actions you want to test for too.
Yes and No. I want to test for a bet and call, but not always before the active players first action.
We may:
1) Check - Face a bet and a call from latter positions.
2) Yet to act - Face a bet and call before our first action.
The code you provided works great, but excludes the situations we check while in an early position.
