Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.
Moderator: Moderators
by NKL300 » Mon Sep 13, 2010 10:14 am
Hi Guys,
Is this available and are their flags for wraps and/or number of outs and nut outs?
Cheers
-
NKL300
-
- Posts: 8
- Joined: Sat Sep 04, 2010 12:33 pm
by kraada » Mon Sep 13, 2010 12:26 pm
It doesn't appear the schema has been updated yet to include omaha.
There are no flags for wraps or specific entries for outs (or nut outs) at this point in time.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by NKL300 » Mon Sep 13, 2010 4:11 pm
Can you publish it or attach to this post?
-
NKL300
-
- Posts: 8
- Joined: Sat Sep 04, 2010 12:33 pm
by kraada » Mon Sep 13, 2010 5:18 pm
If you are capable of reading the SQL notation, it's actually already on your machine in the file schema.postgres.sql - it's a text file that you can open in notepad/wordpad/Word or any similar program. I don't have a pretty PDF-ized version for you or I'd gladly attach it for you.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by NKL300 » Mon Sep 13, 2010 8:24 pm
Thanks, got it
Is there a way of telling what someone lowest holdcard ID is for a certain action.
PFR >= 91 and therefore its easy to find the bottom of their raising range?
Is this possible for a report or HUD :twisted:
-
NKL300
-
- Posts: 8
- Joined: Sat Sep 04, 2010 12:33 pm
by kraada » Tue Sep 14, 2010 8:48 am
Not through a custom statistic; you could build this as a custom report, but the id numbers aren't sorted by overall strength. id 1 is AAAA, id 2 is AAAK, id 3 is AAAQ and so on.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 0 guests