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
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
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
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
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
