Re: sum of numeric column

Thanks for your reply Adrian

What do you want to do with the array?
i want to do a sum of the values of numeric array type column e.g. below

data_numeric
--------------
{2.0}
{1.0}

(4 rows)

Regards

On Wed, Dec 9, 2020 at 4:49 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> 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
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
>