change varchar(10) to varchar()
От | |
---|---|
Тема | change varchar(10) to varchar() |
Дата | |
Msg-id | 20050804161842.22651.qmail@web33314.mail.mud.yahoo.com обсуждение исходный текст |
Ответ на | using interval in a query with a column for the interval value? ("Walker, Jed S" <Jed_Walker@cable.comcast.com>) |
Ответы |
Re: change varchar(10) to varchar()
Re: change varchar(10) to varchar() |
Список | pgsql-novice |
is there a sql command to change a field data type from varchar(10) to varchar()? i tried to do this in pgadmin3, but when i deleted the length (maximum characters) attribute, the OK button stayed grayed out and inactive. as an aside, the OK button becomes active when the length attribute is changed... but turns gray when it is deleted altogether. i don't want to put any arbitrary constraints on my s/n field - especially since there is no performance benefit in doing so per the manual. tia... ps - i can delete and recreate the table with no problems - but i would prefer to learn something for future reference, if possible. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
В списке pgsql-novice по дате отправления: