Waiting for 8.4 – hash based DISTINCT
Today Tom Lane committed patch which gives DISTINCT ability to use hash aggregate – just like GROUP BY.
Search Results for: waiting for
Waiting for 8.4 – RETURNS TABLE
Pavel Stehule wrote, and Tom Lane committed patch which ads new syntax for set-returning functions: “RETURNS TABLE”.
Waiting for 8.4 – variadic functions
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.
Waiting for 8.4 – storage types for table columns
Gregory Stark wrote, and Bruce Momjian committed (on 14th of July) patch which shows storage type in psql.
Waiting for 8.4 – sequence details
On 15th of July, Bruce Momjian commited patch written by Dickson S. Guedes, which: Have psql \d show the value of sequence columns.
Waiting for 8.4 – timing on/off
Yes, finally! David Fetter wrote, and Heikki Linnakangas committed patch which adds on/off arguments to \timing:
Waiting for 8.4 – partial-match support in GIN, and sequence restart
Today we have two interesting patches: patch by Teodor Sigaev and Oleg Bartunov, and committed by Tom Lane, which adds interesting capability to GIN indexes patch by Zoltan Boszormenyi, also committed by Tom, which adds “RESTART” option to ALTER SEQUENCE. With some interesting consequences
Waiting for 8.4 – CASE in pl/PgSQL
Another patch from Pavel Stehule – committed by Tom Lane. This patch adds CASE construction to pl/PgSQL:
Waiting for 8.4 – function stats
Today another great patch, committed by Tom Lane. This patch was written by Martin Pihlak (with some edits by Tom).
Waiting for 8.4 – pl/PgSQL RAISE
Today we have one new feature – extension of plpgsql’s RAISE command.