preflop open allin hole_cards

[nafptq25]

Hi! Is there a separate topic for PT2 SQL questions?
I want to filter all preflop open allin hole_cards.

Code: Select all

SELECT hole_cards FROM tourney_game_players WHERE pre_flop_bet=chip_count AND hole_cards IS NOT NULL

the problem if someone is BB then the pre_flop_bet=chip_count-blind_amt OR if he SB pre_flop_bet=chip_count-(blind_amt/2)
how should i build this into my query?

[kraada]

I don't know the PTv2 database in that much detail so I've moved this thread to the PTv2 PostgreSQL forum and hopefully you'll get a better response there.

[ptrack pat]

What email was used to purchase PT2? I have no record of the name or email you used to register for the site.

[nafptq25]

i pm'd the emailaddress