Random String in PostgreSQL

The Problem Last time I wrote about the common problem with the random function. PostgreSQL has got only the random() function, no function like random(from, to) or random(length) which returns random text of given length. This time I just need a function that returns a random text of given length which can be used like […]

Continue reading →

PostgreSQL 9.1 Best Features

PostgreSQL 9.1 is almost out. That’s great. There are many nice features, so I will mention some most important for me: 1. Per column collation. This is the feature I was waiting for a long time. I’ve written some entries about the problems with collation. Now all of them has gone… from now on the […]

Continue reading →

Django Admin Panel Weirdness

Django Has ORM I’ve started clicking a small Django application. It uses PostgreSQL (that’s obvious). My local PostgreSQL databases log all queries, so I’ve clicked a little bit and checked what queries were sent to database. The whole application has a simple model with class Tag (for tags of course). I’ve configured that to show […]

Continue reading →