On 28th of March 2018, Peter Eisentraut committed patch: Transforms for jsonb to PL/Python Add a new contrib module jsonb_plpython that provide a transform between jsonb and PL/Python. jsonb values are converted to appropriate Python types such as dicts and lists, and vice ...

May 3rd, 2015 by depesz | Tags: , , , , , , , | Comments Off on Waiting for 9.5 – Add transforms feature

On 26th of April, Peter Eisentraut committed patch: Add transforms feature This provides a mechanism for specifying conversions between SQL data types and procedural languages. As examples, there are transforms for hstore and ltree for PL/Perl and PL/Python. reviews by Pavel Stěhule and Andres ...

December 18th, 2013 by depesz | Tags: , , , , , , | Comments Off on Waiting for 9.4 – PL/Perl: Add event trigger support

On 11th of December, Peter Eisentraut committed patch: PL/Perl: Add event trigger support From: Dimitri Fontaine

One of the questions that gets asked quite a lot, is: how can you use variables in your queries? Other databases have them, does PostgreSQL? Actually the answer is "no". But, it is actually very easy to work around, and what's ...

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, ...

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 ...

January 2nd, 2010 by depesz | Tags: , , , , | Comments Off on Waiting for 8.5 – PL/Perl DO

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.