On Sun, Mar 27, 2005 at 09:50:47PM -0800, Josh Berkus wrote:
> Guys,
>
> > > Well, yes, actually. Where in the documentation is a type
> > > conversion expression defined? Do we use NEW and OLD? Or the
> > > name of the column? Or something else?
> >
> > I think the ALTER TABLE page is in dir
Guys,
> > Well, yes, actually. Where in the documentation is a type conversion
> > expression defined? Do we use NEW and OLD? Or the name of the column?
> > Or something else?
>
> I think the ALTER TABLE page is in dire need of a "See also" section, at
> least. And a reference to where is d
On Sun, Mar 27, 2005 at 05:11:43PM -0800, Josh Berkus wrote:
> > ALTER [ COLUMN ] column TYPE type [ USING expression ]
> >
> > Surely you're not expecting it to repeat the complete syntax for
> > .
>
> Well, yes, actually. Where in the documentation is a type conversion
> expression define
Tom,
> ALTER [ COLUMN ] column TYPE type [ USING expression ]
>
> Surely you're not expecting it to repeat the complete syntax for
> .
Well, yes, actually. Where in the documentation is a type conversion
expression defined? Do we use NEW and OLD? Or the name of the column? Or
somethi
Josh Berkus writes:
> ... nowhere in this file (or anywhere else that I can tell) is the syntax for
> the USING expression defined.
Hm? It says
ALTER [ COLUMN ] column TYPE type [ USING expression ]
Surely you're not expecting it to repeat the complete syntax for
.
Folks,
I've noticed that this statement is missing something:
(from sql-altertable.sgml):
ALTER COLUMN TYPE
This form changes the type of a column of a table. Indexes and simple table
constraints involving the column will be automatically converted to use the
new column type by reparsing the