creation date

[Ivan Smahin]

Hello Kim,

Tuesday, April 3, 2007, 2:53:00 PM, you wrote:

> g'day  Ruslan,

>> alter_table_action
>>    |    MODIFY [ COLUMN ] column_definition
> ••••
> hmmm, above that it says:

>         ALTER [ COLUMN ] column_name  < set default default_option | drop
default>>

> I tried as suggested:

> ALTER TABLE stories MODIFY COLUMN web_published DEFAULT 'false'

> and it generated the error:

> 21:48:28: Error: line 1:1: unexpected token: DEFAULT

> ALTER TABLE stories MODIFY COLUMN web_published set DEFAULT 'false'

> gave this:

> 21:51:41: Error: line 1:1: unexpected token: set


ALTER TABLE stories ALTER COLUMN web_published SET DEFAULT false

Or

ALTER TABLE stories ALTER web_published SET DEFAULT false


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com