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)
--------------
{2.0}
{1.0}
(4 rows)
Regards
On Wed, Dec 9, 2020 at 4:49 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx
