I’ve always loved PostgreSQL ever since I started really playing around with it’s potential. Now I always find myself stumbling upon new tricks and extremely elegant solutions to problems, that would be a pain in the ass to handle on the application side. Here’s a cool little feature I found while working on some logging stuff.

SELECT * FROM stats WHERE age(current_timestamp, created) <= ‘30 minutes’;

Very useful in some situations. I still haven’t found a MySQL equivalent.

This entry was posted on Saturday, August 18th, 2007 at 12:01 pm and is filed under Tech, Code, General. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.