On Tue, Jun 12, 2007 at 04:18:32PM +0200, Vincenzo Romano wrote:
> Well, at least on v8.2.4 I cannot return count(*), that is the
> number of lines actually inserted into the table. Nor I can return
> any aggregate function of them.
I don't think anybody considered the possibility of using an aggregate
there, primary because for an aggregate you need a group by. What has
been discussed is nested statements, like:
SELECT a, count(*) FROM
(INSERT <foo> RETURNING a, b)
GROUP BY a;
But I don't think that's implemented (the interactions with triggers
havn't been worked out I think)
> Amk I doing anything wrong or is there some missing sentence in the
> documentation?
When the docs talk about an "expression" they don't mean aggregates,
since they are not functions in the ordinary sense.
Hope this helps,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.