action_lookup table

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

action_lookup table

Postby fiire » Fri Nov 06, 2009 7:15 pm

When I take a look at the action_lookup table I get this:

Code: Select all
0;""
1;"F"
2;"C"
3;"BC"
4;"XF"
5;"X"
6;"CC"
7;"XC"
8;"R"
9;"B"
10;"CF"
11;"RF"
12;"RC"
13;"BF"
14;"XR"
15;"CCF"
16;"CR"
17;"RR"
18;"BR"
19;"CRC"
20;"XRC"
21;"XCF"
22;"BRR"
23;"RRC"
24;"BRC"
25;"RRR"
26;"XRF"
27;"XCC"
28;"BCF"
29;"CCC"
30;"XRR"
31;"BCC"
32;"XCCC"
33;"BRF"
34;"RCC"
35;"XCR"
36;"RRF"
37;"CRR"
38;"XRRC"
39;"BRRC"
40;"RCF"
41;"BRRR"
42;"RRRC"
43;"XRRR"
44;"CRF"
45;"XCRC"
46;"XCCF"
47;"RRRR"
48;"RRRRC"
49;"CCR"
50;"XRCC"
51;"BCR"
52;"CX"
53;"XX"
54;"CCCC"
55;"XB"
56;"XRCF"
57;"BX"
58;"XCB"
59;"CCX"
60;"RX"


I guess F = Fold, C = Call, R = raise, but what is X?
fiire
 
Posts: 2
Joined: Sat May 17, 2008 2:15 pm

Re: action_lookup table

Postby fiire » Fri Nov 06, 2009 7:40 pm

Made some test and querried for 'C' and 'XC'.
It's the same as using filters: 'any call' ; NOT('Facing R, 3B, 4B').
So I presume it stands for some other actions besides F, C, R, because it can't be 'check' alone as there are some ids with X at the end of the sequence.
fiire
 
Posts: 2
Joined: Sat May 17, 2008 2:15 pm

Re: action_lookup table

Postby kraada » Sat Nov 07, 2009 9:30 am

F is fold, C is call, B is bet, R is raise and X is check, or at least it's certainly supposed to be.

You're right though, I see some action strings with checks in the middle and that just doesn't make sense. I just looked through my database and the only time one of the X actions was in the wrong spot, a partial hand history was imported that clearly was missing data. Can you find any full hands that have X as any spot other than the first action?
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 45 guests

cron