Hand Group at Flop and Turn

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Hand Group at Flop and Turn

Postby timooo » Thu May 28, 2009 10:07 am

Hey everybody,

I am looking for the formula used to compute the id_final_hand field in the holdem_hand_player_statistics table.

My intention is to determine the hand_group of a player's holding at flop and turn as well.

I'm sorry if this question has been answered before, I could not find any useful threads.

Cheers
Timooo
timooo
 
Posts: 6
Joined: Sat May 09, 2009 3:20 pm

Re: Hand Group at Flop and Turn

Postby kraada » Thu May 28, 2009 12:35 pm

This data is already built into the database. See the holdem_hand_player_combinations table.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Hand Group at Flop and Turn

Postby timooo » Thu May 28, 2009 12:56 pm

Yes, thanks exactly what I was looking for... :roll:

How do I have to interpret the integer values of id_f_hand_strength?
From the manual I assumed it could be mapped to lookup_hand_groups.id_group but browsing all hands it appears as if the id_f_hand_strength is mostly quite low (0-3) which would correspond to royal flus - four of a kind. Can this be correct?

Thanks alot
Timooo
timooo
 
Posts: 6
Joined: Sat May 09, 2009 3:20 pm

Re: Hand Group at Flop and Turn

Postby timooo » Thu May 28, 2009 1:51 pm

Alrite,
found the according thread.
Thanks alot!
timooo
 
Posts: 6
Joined: Sat May 09, 2009 3:20 pm

Re: Hand Group at Flop and Turn

Postby kraada » Thu May 28, 2009 3:08 pm

No problem :)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 35 guests

cron