Board hand

[TROM]

How to write query if I want for examle hands where on board trips or 1 pair or another hand
Which table in posgres have board hand info ?

[kraada]

The details you want are in the holdem_hand_summary table - holdem_hand_summary.card_1, holdem_hand_summary.card_2 and holdem_hand_summary.card_3 are the flop cards, holdem_hand_summary.card_4 is the turn and holdem_hand_summary.card_5 is the river.

Details on what values these hold can be found in this post.

You'll have to compare them individually to one another - board texture details are not stored in the database.

[TROM]

ok

'card'
2c=1 / 2d=14 / 2h=27 / 2s=40
3c=2 / 3d=15 ...
4c=3
...
Ac=13 / Ad=26 / Ah=39 / As=52


but how in sql query i can recognize what hand I have on board ?

give me 2 example how to recognize that I have trips on flop and all cards have one suit on flop

1 Example
TRIPS
holdem_hand_summary.card_1=1;
holdem_hand_summary.card_2 =14;
holdem_hand_summary.card_3=27;

2 Example
one suit
holdem_hand_summary.card_1=1;
holdem_hand_summary.card_2 =5;
holdem_hand_summary.card_3=10;

[kraada]

If holdem_hand_summary.card_1 % 13 = holdem_hand_summary.card_2 % 13 and holdem_hand_summary.card_2 % 13 = holdem_hand_summary.card_3 % 13 , you have trips.

For your club monotone board, holdem_hand_summary.card_1 <= 13 AND holdem_hand_summary.card_2 <= 13 AND holdem_hand_summary.card_3 <= 13.

[TROM]

for right understand

pair board will be

If
holdem_hand_summary.card_1 % 13 = holdem_hand_summary.card_2 % 13 AND
holdem_hand_summary.card_1 % 13 != holdem_hand_summary.card_3 % 13 OR

holdem_hand_summary.card_2 % 13 = holdem_hand_summary.card_3 % 13 AND
holdem_hand_summary.card_2 % 13 != holdem_hand_summary.card_1 % 13 OR

holdem_hand_summary.card_1 % 13 = holdem_hand_summary.card_3 % 13 AND
holdem_hand_summary.card_1 % 13 != holdem_hand_summary.card_2 % 13 OR

??

[kraada]

Yes, just you'll want to use ()s to offset everything properly and make sure the right things are ANDed or ORed together as you desire.