Hi,
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:
dim=# create table tl(a prefix_range default '[]');
CREATE TABLE
dim=# \d tl
Table "public.tl"
Column | Type | Modifiers
--------+--------------+----------------------------
a | prefix_range | default '[]'::prefix_range
--
dim
Attachment:
signature.asc
Description: This is a digitally signed message part.
