I have a column with mixed data (text and numbers). I want to be able to do an aggregation on a subset of the data that only contains numerical data, however the column type is set to TEXT (postgres). Is there any way i can achieve what i am after? Thanks!