cnt_vpip_sb

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

cnt_vpip_sb

Postby diggingdeeply » Fri Nov 19, 2010 4:32 pm

in the defintion of cnt_vpip_sb, why is it necessary to say "omaha_hand_player_statistics.flg_blind_b = false"?

sum( if[omaha_hand_player_statistics.flg_blind_b = false AND omaha_hand_player_statistics.flg_blind_s AND omaha_hand_player_statistics.flg_vpip, 1, 0] )

Why wouldn't the following be sufficient?

sum( if[omaha_hand_player_statistics.flg_blind_s AND omaha_hand_player_statistics.flg_vpip, 1, 0] )
diggingdeeply
 
Posts: 34
Joined: Fri Oct 22, 2010 8:57 pm

Re: cnt_vpip_sb

Postby kraada » Fri Nov 19, 2010 4:39 pm

Yes that should be sufficient, but there's no real downside to the extra specification.
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 1 guest