Archive for the ‘tips&tricks’ Category

• March 2, 2008 Defining constants in Pl/pgSQL, with a twist posted in postgresql, sql, tips&tricks
• December 11, 2007 PostgreSQL substring search posted in postgresql, query tuning, sql, tips&tricks
• November 2, 2007 Getting current time inside a transaction posted in postgresql, tips&tricks
• July 23, 2007 Decreasing the index size on wide columns posted in data mining, postgresql, query tuning, sql, tips&tricks
• July 19, 2007 Last row in a history table posted in postgresql, sql, tips&tricks
• July 19, 2007 Faster insert for multiple rows posted in postgresql, query tuning, sql, tips&tricks