Re: sum of numeric column

2020-12-09 Thread avi Singh
Thanks Adrian for pointing me in the right direction, i got it working On Wed, Dec 9, 2020 at 5:32 PM Adrian Klaver wrote: > On 12/9/20 5:04 PM, avi Singh wrote: > > 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 a

Re: sum of numeric column

2020-12-09 Thread Adrian Klaver
On 12/9/20 5:04 PM, avi Singh wrote: 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} If you are going to have a single element arrays only then why not just

Re: sum of numeric column

2020-12-09 Thread avi Singh
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 wrote: > On 12/9/20 4:46 PM, avi Singh wro

Re: sum of numeric column

2020-12-09 Thread Adrian Klaver
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 er

sum of numeric column

2020-12-09 Thread avi Singh
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 ERROR: function sum(numeric[]) does not exist Can anyone please help me with this ? Column | Type | Collation | Nullable