Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by Doninorrez » Thu Aug 26, 2021 1:56 pm
Hello,
I searched info about subtrings and read some post and PostgreSQL documentation but still I dont understand well how it works. ¿Can someone explain me as for a dummie?
For example, I am trying to figure out this expression: "substring(cash_hand_summary.str_aggressors_t from 1 for 1)::int = substring(cash_hand_summary.str_aggressors_p from '.$')::int"
Thank you!
-
Doninorrez
-
- Posts: 44
- Joined: Sat Jan 09, 2016 11:25 am
by Flag_Hippo » Fri Aug 27, 2021 6:06 am
That expression is comparing the first character of the turn aggressors string (the turn bettor) to the final character of the preflop aggressors string to make sure they are the same position/player.
This post has information on how the actors and aggressors strings work while
this thread and
this thread discuss in some more detail how you can compare/test those strings.
-
Flag_Hippo
- Moderator
-
- Posts: 14512
- Joined: Tue Jan 31, 2012 7:50 am
by Doninorrez » Wed Sep 01, 2021 10:42 am
As always, great support! Thank you very much!
-
Doninorrez
-
- Posts: 44
- Joined: Sat Jan 09, 2016 11:25 am
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 35 guests