val_f_raise_aggressor_pos (IF NONE HAS RAISED) = ?

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

val_f_raise_aggressor_pos (IF NONE HAS RAISED) = ?

Postby marvin » Wed Oct 28, 2009 8:04 am

ON FLOP:
SB: BET - BUTTON: CALL
1) ABOUT button: holdem_hand_player_detail.val_f_bet_aggressor_pos= 9
2) about SB holdem_hand_player_detail.val_f_bet_aggressor_pos= -1 (WHY HE IS THE BETTOR)
now, there arent raise in this action then..............
3) about SB holdem_hand_player_detail.val_f_raise_aggressor_pos= ??
4) about BUTTON holdem_hand_player_detail.val_f_raise_aggressor_pos = ??
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: val_f_raise_aggressor_pos (IF NONE HAS RAISED) = ?

Postby kraada » Wed Oct 28, 2009 9:11 am

It looks like for both players the value is -1. You can then distinguish -1 from times they were the actual raise aggressor by looking for times they did indeed raise via another condition.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: val_f_raise_aggressor_pos (IF NONE HAS RAISED) = ?

Postby marvin » Wed Oct 28, 2009 9:31 am

ok, this is not a problem,
QUESTION: can i be sure that theese conditions will not change in future :?: ? i dont want write a ton of columns supposing a certain conditions that can be modified in future (i.e. if in new version will be made that raise_agg_pos is=-1 if the raiser is the hero and raise_agg_pos =-2 if the street has not been raised)... :mrgreen: :ugeek: :?
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: val_f_raise_aggressor_pos (IF NONE HAS RAISED) = ?

Postby kraada » Wed Oct 28, 2009 9:47 am

There are no plans to change the value of these database fields that I have heard of.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 2 guests