PostgreSQL
Window Functions example
So, when 8.4 came out there was all those comments about how getting window functions was an awesome addition. Now, it seems that a lot of people seeking for help in …
category
YeSQL
78 posts
PostgreSQL
Happy Numbers
After discovering the excellent Gwene service, which allows you to subscribe to newsgroups to read RSS content ( blogs, planets, commits, etc), I came to read this nice …
PostgreSQL
Playing with bit strings
The idea of the day ain’t directly from me, I’m just helping with a very thin subpart of the problem. The problem, I can’t say much about, let’s …
PostgreSQL
Partitioning: relation size per “group”
This time, we are trying to figure out where is the bulk of the data on disk. The trick is that we’re using DDL partitioning, but we want a “nice” view of size per …
PostgreSQL
Finding orphaned sequences
This time we’re having a database where sequences were used, but not systematically as a default value of a given column. It’s mainly an historic bad idea, …
PostgreSQL
Importing XML content from file
The problem was raised this week on IRC and this time again I felt it would be a good occasion for a blog entry: how to load an XML file content into a single field? The …