Re: change varchar(10) to varchar()

--- Jaime Casanova <systemguards@gmail.com> wrote:

> On 8/4/05, operationsengineer1@yahoo.com
> <operationsengineer1@yahoo.com> wrote:
> > 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.
> >
>
> use text datatype, instead


worked like a charm.  are there any advantages to
using text of varchar() or vice versa?  are they equal
and just personal preference?



____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs