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.
May 8th, 2008 by depesz | Tags: bazy danych, domain, mysql, plperl, plpgsql, postgresql, timestamp | 6 comments »
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.
