[sqlite] Group By Rollup and Build Date

[Robert L Cochran]

I tried using the 'group by rollup' clause like so:

[EMAIL PROTECTED] elections]$ sqlite3 elections.db
SQLite version 3.2.7
Enter ".help" for instructions
sqlite> select rc_cd, rp_cd, votes from results where rc_cd in 
('ivy000', 'put000') group by rollup (rc_cd) order by rc_cd, rp_cd;
SQL error: no such function: rollup
sqlite>
Are there any plans to support this in the future? I realize that 
whether or not there are, it doesn't excuse me for using erroneous or 
bad SQL.

Secondly, as you can see above I use the SQLite command line a fair bit. 
I'd like to see the build date show up on the command line when I start 
it. For example
SQLite version 3.2.7 built on 2005-11-02 02:00:35
...

Thanks

Bob Cochran
Greenbelt, Maryland, USA