Posts Tagged ‘plperl’

Writing sprintf, and overcoming limitations in pl/perl

2008-08-01 12:44:17 CEST | 4 Comments | Tags: , , , ,

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.

- MORE -

MySQL’s timestamp in PostgreSQL

2008-05-08 17:16:43 CEST | 6 Comments | Tags: , , , , , ,

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.

- MORE -