> Mysql is planning on making this work: > > SELECT id, @a:=COUNT(*), SUM(sum_col)/@a FROM table_name GROUP BY id. > > Do we have anything like it (After a discussion with Tom i figure no). > User variables is nice, especially in these kind of queries.
Well of course they have to make that work - they don't have subselects :P Chris ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
