Thread: 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
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.
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 gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
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 Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
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