how to do prefix_range default value?

From: Tony Liao <tonyliao(at)yuehetone(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: how to do prefix_range default value?
Date: 2009-04-03 03:03:37
Message-ID: 8f750b7c0904022003p705e77fqdc7040bfe02eda1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi,all
I have installed prefix contrib,it works well.
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 [];

plz,how can I alter default value []?

thanks

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Justin 2009-04-03 04:32:36 Re: Text Description of Current Exception
Previous Message Ward Eaton 2009-04-02 21:07:58 Text Description of Current Exception