During last month or so, Tom Lane commited changes in PostgreSQL, which were foundations for adding hash-based versions of popular features.
I already described first such feature – DISTINCT.
Now, there were 3 more commits which were related to this:
Continue reading Waiting for 8.4 – UNION / INTERSECT / EXCEPT
Today Tom Lane committed patch which gives DISTINCT ability to use hash aggregate – just like GROUP BY.
Pavel Stehule wrote, and Tom Lane committed patch which ads new syntax for set-returning functions: “RETURNS TABLE".
Pavel Stehule wrote, and then Tom Lane committed (on 16th of July), patch which adds to PostgreSQL support for functions with variable number of arguments.
Gregory Stark wrote, and Bruce Momjian committed (on 14th of July) patch which shows storage type in psql.
Continue reading Waiting for 8.4 – storage types for table columns
On 15th of July, Bruce Momjian commited patch written by Dickson S. Guedes, which:
Have psql \d show the value of sequence columns.
Yes, finally! David Fetter wrote, and Heikki Linnakangas committed patch which adds on/off arguments to \timing:
Today we have two interesting patches:
Continue reading Waiting for 8.4 – partial-match support in GIN, and sequence restart
Another patch from Pavel Stehule – committed by Tom Lane. This patch adds CASE construction to pl/PgSQL:
Today another great patch, committed by Tom Lane. This patch was written by Martin Pihlak (with some edits by Tom).