Postgresql, plperl and custom rowtypes

Posted on September 14, 2007August 10, 2025 by Christopher

I had a problem that I needed to solve recently, and the most elegant way to do this was with a stored procedure. However, the procedure needed to return 2 columns – an index id and a sort order. One way to tackle this is to have the plperl function called by a wrapping plpgsql […]... Read More

OpenSSL Self-Signed Certificate one-liner.

Posted on August 8, 2007August 10, 2025 by Christopher

Ok, this is a purely selfish post. I have to do this rarely enough that every time I do, I have to look it up. I could put this somewhere, perhaps in my little bag of tricks called ‘you should remember this’. Unfortunately, I don’t have that bag, and I’ll never remember it. So, hopefully […]... Read More

Fire!

Posted on July 26, 2007August 14, 2025 by Christopher

On Monday, my ‘net, phone and cable – all provided by the same company – were all knocked out by a big fire that destroyed 2 fairly popular bar/restaurants 2 blocks away (‘A’ is my place, ‘B’ is fire) from my place. I live in a part of Montréal called ‘the plateau’, which is a […]... Read More

Christopher Murtagh

Ponderer, feminist, musician and dad.

Author: Christopher

Postgresql, plperl and custom rowtypes

OpenSSL Self-Signed Certificate one-liner.

Fire!