Filter for relative position?

[tennishepcat]

Is it equally as difficult getting this filter preflop?

The scenario I am interested in are the bubble stages for sit n go's, where I am facing an all in and am last to act.

[BillGatesIII]

I think it works In my previous post, only closing the action out of position to the last raiser was filtered. In the expression below I added in position filtering as well. The expression looks a little messy though

Please keep in mind it only filters the last possibility to close the action. So for example, if you're the button and on the flop the SB checks and the CO bets, you cannot close the action because the SB has to act behind you. Then, if you call the bet of the CO and the SB raises and the CO calls or folds, you will be able to close the action. So this hand will go through the filter. Don't know if that's what you want? And there is no check for all in players.

Code: Select all

position = coalesce(
  (select min(chps.position)
   from cash_hand_player_statistics chps
   join cash_hand_summary chs on chps.id_hand = chs.id_hand
   where chs.id_hand = cash_hand_player_statistics.id_hand
   and chps.flg_f_saw
   and chs.cnt_players_f >= 3
   and char_length(chs.str_aggressors_f) >= 1
   and chps.position > substring(chs.str_aggressors_f from '.$')::int),
  (select min(chps.position)
   from cash_hand_player_statistics chps
   join cash_hand_summary chs on chps.id_hand = chs.id_hand
   where chs.id_hand = cash_hand_player_statistics.id_hand
   and chps.flg_f_saw
   and chs.cnt_players_f >= 3))

[kraada]

That is messy but looks like it should work