Dimitri, thank you.it works well.
yours,tony
2009/4/6 Dimitri Fontaine <[email protected]>
> 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
>
