Waiting for 8.4

From PostgreSQL Wiki

This series from Hubert Lubaczewski covers features added to 8.4 as they are committed:

• Common Table Expressions (WITH queries)
• new FSM (Free Space Map)
• database-level lc_collation and lc_ctype
• pgbench with timed execution
• case insensitive text ( citext )
• UNION / INTERSECT / EXCEPT
• ordered data loading in pg_dump
• hash based DISTINCT
• RETURNS TABLE
• variadic functions
• storage types for table columns
• sequence details
• timing on/off
• partial-match support in GIN, and sequence restart
• CASE in pl/PgSQL
• function stats
• pl/PgSQL RAISE
• psql vs. tabs + wrapped output
• pg_conf_load_time, time-related generate_series and enum values in \dT+
• RETURN QUERY EXECUTE and cursor_tuple_fraction
• \o and \d+ in psql
• generate_subscripts
• “EXPLAIN VERBOSE”
• current_query()
• EXECUTE USING in plpgsql
• \l+ and \d in psql
• Statement-level ON TRUNCATE triggers
• quote_nullable()
• Report queries in a deadlock
• enum type for guc parameters
• limit (select ) and optional as in select

Or you can just go directly to series index.