I went to alter a table, to add a column like so:
alter table passwd add column spamblock bool DEFAULT 'TRUE'
this added the new column of type bool but did not make the default true.
Any suggestions?
Kevin
--------------------------------------------------------------------
Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612
kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------