Horton

Re: 7.4 Wishlist

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

View thread View on postgr.es
From: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
To: "Magnus Naeslund(f)" <mag@fbab.net>, <pgsql-hackers@postgresql.org>
Date: 2002-12-02T20:25:34Z
Lists: pgsql-hackers, pgsql-general 
> 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