hi i got a problem that when using the posgres code i get value 1 from a player i tested it instead of value 2....did i miss something in the table relation ?
"SELECT sum((case when(holdem_hand_player_statistics.flg_f_cbet)\
AND (holdem_hand_player_statistics.flg_t_cbet) \
AND (holdem_hand_player_statistics.flg_R_cbet) \
AND ((lookup_hand_ranks.id_group>8) or (holdem_hand_player_combinations.flg_r_1pair \
AND lookup_hand_ranks.id_group=8 \
AND holdem_hand_player_combinations.id_r_hand_strength<3 )) \
AND (holdem_hand_player_detail.val_r_bet_made_pct >100) then 1 else 0 end)) as result \
FROM holdem_hand_player_statistics, holdem_hand_player_detail, holdem_hand_player_combinations, lookup_hand_ranks, player as P \
WHERE holdem_hand_player_statistics.id_hand = holdem_hand_player_combinations.id_hand AND holdem_hand_player_statistics.id_final_hand = lookup_hand_ranks.id_hand_rank AND holdem_hand_player_statistics.id_player = P.id_player AND holdem_hand_player_statistics.id_hand = holdem_hand_player_detail.id_hand \
many thanks
daniel