def_opp vs opp Q?

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

def_opp vs opp Q?

Postby warrior04 » Fri Mar 15, 2013 2:41 pm

I have a question regarding the nature of the fields flg_x_xxx_def_opp and flg_x_xxx_opp in holdem_hand_player_statistics.

for simplification let take for example: flg_t_4bet_opp and flg_t_3bet_def_opp
from what i understand if a player is facing 3bet it should be equal to having a 4bet opportunity.
but because in practice it's 4bet+ it should look like flg_t_4bet_opp >= flg_t_3bet_def_opp
that should be true in theory, right?

when i tried to run this 2 queries in postgresql i got a very different result then what i expected
SELECT * FROM holdem_hand_player_statistics WHERE flg_t_3bet_def_opp (return ~3000 raws)
SELECT * FROM holdem_hand_player_statistics WHERE flg_t_4bet_opp (return ~700 raws)

I must be missing something here...
warrior04
 
Posts: 39
Joined: Wed Jul 21, 2010 11:44 am

Re: def_opp vs opp Q?

Postby kraada » Fri Mar 15, 2013 5:19 pm

If you're facing a 3bet shove (or a 3bet for more than your stack) you have a 3bet_def_opp but not a 4bet_opp. That's the most likely reason for the behavior you're describing.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: def_opp vs opp Q?

Postby warrior04 » Sat Mar 16, 2013 3:34 pm

thanks a lot :)
just confirmed it and it's seem to be exactly the issue.
warrior04
 
Posts: 39
Joined: Wed Jul 21, 2010 11:44 am


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

Who is online

Users browsing this forum: No registered users and 12 guests

cron