On 12/9/20 4:46 PM, avi Singh wrote: > I have a table structure and want to do a sum of column type i.e > numeric. How can I do it ? when i try sum function i get this error
You don't have a numeric type you have a numeric array type.
> > ERROR: function sum(numeric[]) does not exist
Hence the error above.
> > Can anyone please help me with this ?
What do you want to do with the array?
> > Column | Type | Collation | > Nullable | Default > ----------------------------+--------------------------+-----------+----------+--------- > grid_id | bigint | | > not null | > as_of_date | date | | > not null | > cell_id | bigint | | > not null | > last_event_timestamp_local | timestamp with time zone | | > | > last_event_id | bigint | | > | > column_id | bigint | | > | > column_name | character varying(50) | | > | > row_id | bigint | | > | > data_type_id | smallint | | > | > data_numeric | numeric[] | | > | > data_string | character varying[] | | > | > > e.g. of values in numeric type column > > data_numeric > -------------- > {2.0} > {1.0} > > Regards > Prabhjot