WhiteRider wrote:An "actor" is someone who voluntarily puts money/chips in the pot - either call or raise, but not blinds.
"substring ... from 1 for 1" means 1 character from position 1, so the first character. Because this is a character we can use ::int to cast it to an integer, although in this case we're just checking if they're equal so that isn't strictly necessary.
"from 2 for 1" means 1 character from the second position, so the second character.
Therefore:
substring(cash_hand_summary.str_aggressors_f from 1 for 1) ::int = substring(cash_hand_summary.str_actors_f from 2 for 1)::int
..says that the first aggressor (first raiser) was the same as the first actor (first call or raise), so no-one could have limped before the first raise.
That isn't the relevant part to this case though. You'll need to compare the position of the relevant raiser or caller (using substring like above) to the position of the player the stat is for, as discussed in the thread Flag_Hippo linked you to.
So if i understandm are these statements correct:
Open Betting would not count as an actor or aggressor?
+
(cash_hand_summary.str_aggressors_f from 1 for 1) = First Aggressor same as first Actor.
(cash_hand_summary.str_aggressors_f from 2 for 1) = Second Aggressor same as first Actor.
(cash_hand_summary.str_aggressors_f from 2 for 2) = Second Aggressor same as second Actor.
(cash_hand_summary.str_aggressors_f from 1 for 3) = First Aggressor same as third Actor.
+
(cash_hand_summary.str_actors_f from 2 for 1) = 2 Actors after active player position.
(cash_hand_summary.str_actors_f from 1 for 2) = 2 Actors before active player position.
ALso:
?
I notice "> cash_hand_player_statistics.position" or "< cash_hand_player_statistics.position". Is this to assign the potions?
Eg:
> cash_hand_player_statistics.position = From a latter position
> cash_hand_player_statistics.position = From an Earlier position
Hopefully i got something right, i want to understand this!