Today, on #postgresql on IRC, guy (can't contact him now to get his permission to name him), said: I have a table called problematic_hostnames. It contains a list of banned hostnames in column "hostname" (varchar). I would like to display the ...
In PostgreSQL 8.2, we got "RETURNING" clause in INSERT/UPDATE/DELETE queries. Unfortunately it could not be used as source of rows for anything in sql. insert into table_backup delete from table where ... returning *; Well, it's still not possible, but it is a ...
SoftNum asked on irc: < SoftNum> does postgresql have a config option to automatically trim (both ' ' from blah) on string compares? So, can you? Of course there is no such option, but maybe there is a way to tell PostgreSQL to ...
Cezio wrote post about removing elements from arrays in PostgreSQL. Unfortunately his blog engine requires registration before comment, which I don't like, so I decided to comment using my own blogspace.
Every now and then I see people ask the question - how to create table if it doesn't exist yet, how to drop it, but only if it does exist and so on. Well, starting from 8.2 dropping should be not ...
another new, cool feature commited by tom lane: "Support statement-level ON TRUNCATE triggers." original patch was submitted by simon riggs, and tom commited it today/yesterday (depending on time zone).
