array_agg issue

[4StarGen]

When I try to use array_agg I get a strange error

Code: Select all

ARRAY_AGG(
CASE
        WHEN cash_hand_player_statistics.flg_p_first_raise
        THEN (cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb)::double precision
        ELSE NULL
    END)


The expression is correct, PT4 validates it, when I click to save it saves it but after a second it tells me I need to enter an expression and the column just vanish

[Flag_Hippo]

I don't believe a column can hold an array and that is likely why this is being rejected and not saved.

[4StarGen]

But this method has been used before

https://www.pokertracker.com/forums/vie ... gg#p330670

[Ventilatorrr]

I do not know enough about this to be able to help, but someone will get back to you next week.

[4StarGen]

Ty Ventilatorrr :)

[WhiteRider]

The example in the thread you linked turns the array into a string using "array_to_string", so you may want to try that here too.

[4StarGen]

Ty mate, gonna try that