---
title: "This Week's PostgreSQL News (#62)"
publication: "Postgres Weekly"
issue: 62
published_at: "2014-06-18"
canonical_url: "https://postgresweekly.com/issues/62"
---

Postgres Weekly Issue 62 - June 18, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/62)**Postgres Weekly****Issue 62**
June 18, 2014As always, thanks to [Craig Kerstiens](https://twitter.com/craigkerstiens) for continuing to curate Postgres Weekly for us :-) Be sure to hit him up on Twitter with any appreciation or ideas.[Aggregate Functions Gone Bad, and the Joins Who Made Them that Way](http://www.looker.com/news/blog/aggregate-functions-gone-bad-and-joins-who-made-them-way?utm_source=postgresweekly&utm_medium=email)Joins can be extremely powerful, yet can also sometime give you results you’re not expecting. When aggregating these miscues may be harder to find, here’s a look at a few examples._Brett Sauve_[Foreign Tables (in Postgres) are not as Useful as I Hoped](http://bonesmoses.org/2014/06/11/foreign-tables-are-not-as-useful-as-i-hoped/?utm_source=postgresweekly&utm_medium=email)Foreign tables promise a great future for Postgres and connecting to multiple data sources, but all is not perfect with them yet as there’s some clear areas for improvement highlighted here._Shaun M. Thomas_[PostGIS: PostgreSQL's Spatial Partner - Part 1](http://shisaa.jp/postset/postgis-postgresqls-spatial-partner-part-1.html?utm_source=postgresweekly&utm_medium=email)Heard about PostGIS, the geospatial support within Postgres, but not explored it yourself? Here’s a great quick dive into the lay of the land there of some key concepts and how to use them._Tim van der Linden_[Postgres 9.4 feature highlight: GiST operator class for inet and cidr datatypes](http://michael.otacoo.com/postgresql-2/postgres-9-4-feature-highlight-gist-inet-datatype/?utm_source=postgresweekly&utm_medium=email)The inet and cidr datatypes have been handy, but not always perfectly performant for some common use cases. Now with new GiST operator classes queries against subnet or other parts can be very efficient._Michael Paquier_[Parse Postgresql Queries In Ruby](https://pganalyze.com/blog/parse-postgresql-queries-in-ruby.html?utm_source=postgresweekly&utm_medium=email)Want access to the Postgres parse tree in something other than directly in Postgres? Here’s an awesome tool for getting the parse tree in Ruby to make building applications that take advantage of it easier._Lukas Fittl_[pgsql-listen-exchange: RabbitMQ Exchange That Publishes Messages Received From PostgreSQL Notifications](https://github.com/aweber/pgsql-listen-exchange?utm_source=postgresweekly&utm_medium=email)A RabbitMQ exchange type that translates PostgreSQL NOTIFY messages to AMQP messages and publishes them to bound queues. The PostgreSQL NOTIFY message channel is used as the routing key for the message using direct exchange style routing mechanics._AWeber_[All Your Base: A Database Conference for Web Developers - Oxford, 17 October 2014](http://allyourbaseconf.com/2014/?utm_source=postgresweekly&utm_medium=email)In a sense, this newsletter actually got its start at All Your Base, a database conference for web developers. If you’re in England or looking for an excuse to go, this is a great one full of information on a slew of databases. If you want to see the overall quality, you can watch [the videos from 2013 here.](https://vimeo.com/album/2683752)_All Your Base Conf_Curated by [Craig Kerstiens](http://craigkerstiens.com/) and published by [Cooper Press](https://cooperpress.com/).
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q2.pdf)

 © 2017 Cooper Press Ltd. [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK[Update your email address](*|UPDATE_PROFILE|*)
or [unsubscribe here](*|UNSUB|*)