[GENERAL] New 8.4 features
Hello, Some of the new language features in 8.4 seem like pretty major additions. I know that the window functions will be very useful. There have been many times in the past when I've wanted to aggregate in this way: http://elegantcode.com/2009/01/04/sql-window-clause/ If this is possible now it'll help massively in rapid prototyping - in the past, reports involving aggregates have needed the most time to develop. Another interesting feature is recursive SQL. I know 8.4 is only just in beta but it would be good to learn what is (and isn't) possible. These seem like the sorts of things that would get good writeups at varlena.com but I see there haven't been any new posts there in a couple of years. My question is, is anyone planning to blog / write focussing on these features? Oliver Kohll www.gtwm.co.uk - company www.gtportalbase.com - product -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] New 8.4 features
There's quite few articles about it on depesz.com. And since I started to blog recently about my own skirmishes/encounters with postgresql too - I'll probably write something about it. So far, personally - I used WITH() for PI calculations, as an example. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] New 8.4 features
On Mon, 20 Apr 2009, Oliver Kohll - Mailing Lists wrote: My question is, is anyone planning to blog / write focussing on these features? There's been regular blog posting from Hubert Lubaczewski in particular covering 8.4 features for over a year now. http://www.planetpostgresql.org/ is a good place to find PostgreSQL oriented blogs at. I've been collecting 8.4 related blog and talk presentations onto a list at http://wiki.postgresql.org/wiki/Waiting_for_8.4 and encourage others to expand on that with ones I've missed. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] New 8.4 features
Greg Smith wrote: I've been collecting 8.4 related blog and talk presentations onto a list at http://wiki.postgresql.org/wiki/Waiting_for_8.4 and encourage others to expand on that with ones I've missed. http://lwn.net/SubscriberLink/328591/3fdb051da4bfee26/ -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] New 8.4 features
On Mon, 2009-04-20 at 16:17 +0100, Grzegorz Jaśkiewicz wrote: There's quite few articles about it on depesz.com. And since I started to blog recently about my own skirmishes/encounters with postgresql too - I'll probably write something about it. So far, personally - I used WITH() for PI calculations, as an example. David Fetter also has a lot of material (mostly talk slides) at http://fetter.org/ Jeff Davis -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general