On 18th of February, Alvaro Herrera committed patch: Convert Postgres arrays to Perl arrays on PL/perl input arguments   More generally, arrays are turned in Perl array references, and row and composite types are turned into Perl hash references. This is done recursively, in ...

I have a mixed love/hate relationship with tests. I hate writing them. I hate remembering to add them when I'm in the zone, and application code is flowing freely from the tips of my fingers. But when I do add them, I ...

Just recently I wrote about DO command in PostgreSQL 8.5, and now (since 29th of November) we have DO with PL/Perl support. Written by Joshua Tolley and committed by Tom Lane, the patch: Log Message: ----------- Add support for anonymous code blocks (DO blocks) ...

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.

MySQL has this nifty/annoying feature/bug of special data type "TIMESTAMP". It is like a DATETIME, but it gets automatically updated whenever you modify the row. I'll try to add the same feature to PostgreSQL.