Querying the db

[kukimus]

hello

im trying to query the db.. just for a simple test for now..

here is my code :

###################################################
SELECT
SUM(
(SUM(flg_f_open)) / (SUM(flg_f_open_opp)))



FROM player, holdem_hand_player_detail


WHERE

player_name_search='crazyyandre'
#####################################################

But i get errors.. and i whas wondering what am i doing wrong

regards
k.

[kukimus]

i need to sum up all the times he bet divided by all the times he had the chanse to bet..

and im a noob so if anybody care to give me a hint it would be great

regards
k.

[kraada]

PT3 has this stat built in already it's called "Bet Flop".

[kukimus]

i now

[kraada]

You could pull a more simple version of the stat out by looking in the holdem_cache table, but the actual query to calculate the data is quite a bit more complicated.

[kukimus]

im getting this why ?

ERROR: function if(boolean, integer, integer) does not exist
LINE 5: sum(if(flg_f_open,1,0))

[kraada]

The if() function isn't a part of PostgreSQL; PT3 has it's own if() wrappers. If you're doing that in a column definition, you want to use []s not ()s, also.