I usually write about PostgreSQL, but lately someone asked for help, and one of the problems was similar to sudo command from title. This was not the first time I saw it, so figured, I'll write a blogpost about it, just ...

On 8th of November, Tom Lane committed patch, which doesn't provide any new features, but removes one of the more annoying footguns in PostgreSQL: Prevent invoking I/O conversion casts via functional/attribute notation.   PG 8.4 added a built-in feature for casting pretty much ...

July 10th, 2009 by depesz | Tags: , , , | No comments »

I had today a very weird situation. From my laptop, I ssh to another system, and from there to yet another. On this final system I noticed that vim starts relatively slow. i.e. this command: time vim -u /dev/null -c ":q" returned time in ...

February 10th, 2009 by depesz | Tags: , , , , , , , | 4 comments »

I was lately writing some program for a client of mine, which used UPC codes matching. Since the codes are given in various ways, there was decision to pad the codes with leading zeros - up to 12 characters. The code has ...