On 29th of July, Tom Lane committed patch written by David E. Wheeler, which added new contrib module: citext.
Continue reading Waiting for 8.4 – case insensitive text ( citext )
Waiting for 8.4 – UNION / INTERSECT / EXCEPT
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
Removing elements from arrays
Cezio wrote post about removing elements from arrays in PostgreSQL.
Unfortunately his blog engine requires registration before comment, which I don't like, so I decided to comment using my own blogspace.
Waiting for 8.4 – hash based DISTINCT
Today Tom Lane committed patch which gives DISTINCT ability to use hash aggregate – just like GROUP BY.
Waiting for 8.4 – RETURNS TABLE
Pavel Stehule wrote, and Tom Lane committed patch which ads new syntax for set-returning functions: “RETURNS TABLE".
Writing sprintf, and overcoming limitations in pl/perl
Having new VARIADIC functions, I decided it would be cool to be able to write sprintf() function.
Basically the idea is simple, plperl function, which takes “format", and list of arguments and returns generated output.
Continue reading Writing sprintf, and overcoming limitations in pl/perl
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.
Continue reading Waiting for 8.4 – storage types for table columns
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.
Lack of new posts
Sorry for delay in writing new posts – especially new information about “what's new in pg 8.4".
I've been on vacation, and crashed my car. New posts will be coming this week – for starters – I have 244 unread mails from pg-committers mailing list, so you can expect at least couple of new things in 8.4 🙂