[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4783: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3888)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4785: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3888)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4786: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3888)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4787: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3888)
Interesting PT (Postgres) Queries - Live Poker Forums

Advanced search

Interesting PT (Postgres) Queries

Discuss PokerTracker, GT+, PokerAce and Others

Moderators: excession, LPF Police Department

Interesting PT (Postgres) Queries

Postby APerfect10 » Mon Aug 29, 2005 11:11 am

Last edited by APerfect10 on Thu Sep 01, 2005 5:17 pm, edited 3 times in total.
User avatar
APerfect10
 
Posts: 208
Joined: Mon Feb 14, 2005 2:11 pm
Location: Pennsylvania

Set over set wins

Postby APerfect10 » Mon Aug 29, 2005 11:13 am

User avatar
APerfect10
 
Posts: 208
Joined: Mon Feb 14, 2005 2:11 pm
Location: Pennsylvania

Set Over Set Losses

Postby APerfect10 » Mon Aug 29, 2005 11:15 am

User avatar
APerfect10
 
Posts: 208
Joined: Mon Feb 14, 2005 2:11 pm
Location: Pennsylvania

Postby T-Rod » Mon Aug 29, 2005 1:19 pm

Thanks for posting Aperfect.

I've been using the default Access DB. Any reason I shouldn't convert to Postgres?

Tim
User avatar
T-Rod
 
Posts: 5794
Joined: Fri Jun 03, 2005 12:09 pm
Location: Dallas, Texas

Postby APerfect10 » Tue Aug 30, 2005 8:25 am

User avatar
APerfect10
 
Posts: 208
Joined: Mon Feb 14, 2005 2:11 pm
Location: Pennsylvania

Postby Twelver » Tue Aug 30, 2005 9:00 am

computer noob.....how would i go about switching to postgres?
Mekos King (10:21:59 PM): one of the first rules of manlaw
Mekos King (10:22:06 PM): is never ever try to suck backup to a bitch
Mekos King (10:22:09 PM): who caught u cheatin
Mekos King (10:22:23 PM): unless your married and would lose like money inna divorce
Mekos King (10:22:33 PM): then u suckup just long enuf to get close enough to killer obv

Heat517163 (5:05:37 PM): black people man
Heat517163 (5:05:40 PM): they travel in packs
User avatar
Twelver
 
Posts: 3830
Joined: Sun Jun 12, 2005 10:03 am
Location: Atlanta

Postby APerfect10 » Tue Aug 30, 2005 10:40 am

User avatar
APerfect10
 
Posts: 208
Joined: Mon Feb 14, 2005 2:11 pm
Location: Pennsylvania

Postby Twelver » Tue Aug 30, 2005 1:44 pm

Thanks
Mekos King (10:21:59 PM): one of the first rules of manlaw
Mekos King (10:22:06 PM): is never ever try to suck backup to a bitch
Mekos King (10:22:09 PM): who caught u cheatin
Mekos King (10:22:23 PM): unless your married and would lose like money inna divorce
Mekos King (10:22:33 PM): then u suckup just long enuf to get close enough to killer obv

Heat517163 (5:05:37 PM): black people man
Heat517163 (5:05:40 PM): they travel in packs
User avatar
Twelver
 
Posts: 3830
Joined: Sun Jun 12, 2005 10:03 am
Location: Atlanta

Postby neverslowplay_AA » Tue Aug 30, 2005 5:00 pm

A couple of questions about these queries.
1) If I don't add a date will it query entire database?
2) With set over set is that for pocket pairs turned into sets or can it be pair onboard that is trips?
Thanks
User avatar
neverslowplay_AA
Enthusiast (B&M & Online)
 
Posts: 92
Joined: Wed Dec 15, 2004 10:10 pm
Location: Vista,Ca

Postby APerfect10 » Wed Aug 31, 2005 1:47 am

User avatar
APerfect10
 
Posts: 208
Joined: Mon Feb 14, 2005 2:11 pm
Location: Pennsylvania

Postby neverslowplay_AA » Wed Aug 31, 2005 12:57 pm

I asked those questions because I have more set over set wins and losses than total sets. Did I do something wrong or am I reading the data wrong?
User avatar
neverslowplay_AA
Enthusiast (B&M & Online)
 
Posts: 92
Joined: Wed Dec 15, 2004 10:10 pm
Location: Vista,Ca

Postby APerfect10 » Thu Sep 01, 2005 5:13 pm

User avatar
APerfect10
 
Posts: 208
Joined: Mon Feb 14, 2005 2:11 pm
Location: Pennsylvania

Postby NorthView » Sat Sep 03, 2005 6:52 am

Nice queries, APT.

It's worth mentioning that dates can be entered in the more user-friendly format of d mmm yyyy eg '1 sep 2005'. This implies 1 Sep 2005 00:00:00, so will return data from and including the first of September onwards.
User avatar
NorthView
 
Posts: 5998
Joined: Sun Apr 03, 2005 8:02 am
Location: Not another flush card

Postby neverslowplay_AA » Sat Sep 03, 2005 11:37 am

It still comes up the same stats but the one you posted on PokerTracker website works fine. Thanks.
User avatar
neverslowplay_AA
Enthusiast (B&M & Online)
 
Posts: 92
Joined: Wed Dec 15, 2004 10:10 pm
Location: Vista,Ca

Postby APerfect10 » Sun Sep 04, 2005 9:18 pm

User avatar
APerfect10
 
Posts: 208
Joined: Mon Feb 14, 2005 2:11 pm
Location: Pennsylvania

Next

Return to PokerTracker and Other Tools

Who is online

Users browsing this forum: No registered users and 2 guests

cron