Re: [DOCS] Missing doc on expression format for ALTER TABLE

2005-03-28 Thread David Fetter
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

Re: [DOCS] Missing doc on expression format for ALTER TABLE

2005-03-27 Thread Josh Berkus
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

Re: [DOCS] Missing doc on expression format for ALTER TABLE

2005-03-27 Thread Alvaro Herrera
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

Re: [DOCS] Missing doc on expression format for ALTER TABLE

2005-03-27 Thread Josh Berkus
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

Re: [DOCS] Missing doc on expression format for ALTER TABLE

2005-03-26 Thread Tom Lane
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 .

[DOCS] Missing doc on expression format for ALTER TABLE

2005-03-26 Thread Josh Berkus
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