February 10th, 2009 by depesz | Tags: gotcha, length, lpad, postgresql, repeat, rpad, trim, truncate | 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 ...
May 17th, 2008 by depesz | Tags: bazy danych, gin, pg84, postgresql, prefix, sequence, truncate, tsearch | 1 comment »
Today we have two interesting patches: patch by Teodor Sigaev and Oleg Bartunov, and committed by Tom Lane, which adds interesting capability to GIN indexes patch by Zoltan Boszormenyi, also committed by Tom, which adds "RESTART" option to ALTER SEQUENCE. With some ...
March 28th, 2008 by depesz | Tags: bazy danych, databases, pg84, plpgsql, postgresql, sql, triggers, truncate | 4 comments »
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).
