Re: ERROR: cannot use aggregate function in RETURNING (in UPDATE) - Mailing list pgsql-novice

Thanks Tom, that worked out great.

--

Regards

Dinesh

From: Tom Lane-2 [via PostgreSQL] [mailto:[hidden email]]
Sent: Sunday, March 24, 2013 3:26 PM
To: dinesh
Subject: Re: ERROR: cannot use aggregate function in RETURNING (in UPDATE)

dinesh <[hidden email]> writes:
> I get an error saying cannot use aggregate function in RETURNING.
> Is this a bug or a feature?

Well, it's not a bug.  RETURNING is defined as returning one row per
row inserted/updated/deleted, so aggregates are nonsensical there.

In recent versions you could put the UPDATE RETURNING inside a WITH,
and then do the aggregation in a SELECT over that.

                        regards, tom lane


--
Sent via pgsql-novice mailing list ([hidden email])
To make changes to your subscription:
click here.
NAML