On Friday 03 April 2009 05:03:37 Tony Liao wrote: > now I want to insert default value [] to prefix column,because if the > prefix column is NULL,the returns are not I want (with prefix @>'text').I > alter column prefix default [],it return error: > ERROR: syntax error at or near "[" > LINE 2: ALTER COLUMN prefix SET DEFAULT [];
You need to have the value protected into quotes, as it's a literal: