Re: altering a table to set serial function

On Wed, Jul 28, 2004 at 05:09:33AM -0700, Prabu Subroto wrote:
> Dear Scott...
> 
> My God.... so I can not use "alter table" to define a
> column with int data type?

eh? Sure you can:

alter table x add column y integer;

What's he's saying is that the "serial" shortcut isn't there and
proceeded to tell you how to do it manually...
-- 
Martijn van Oosterhout      http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.