Re: [GENERAL] data type "serial"

>
> So how do you store something in data type serial?
> I've created the column but everytime I attempt to do an update I get
> back the error message that I can't store a duplicate key.
>
> table_col_seq.last_value = 1
> increment = 1
> maxvalue = 2billion something
>
> I've tried storing 1,2,some other number in "serial" in the main
> table to no avail. What is the magic to get this to work. There
> appears to be no documentation anywhere on the necessary SQL commands
> to cycle the generator. I've tried the method used for Oracle SQL but
> that does not work. I'm a bit of a newbie at this.
>
> Michael
> Michael(at)bizsystems(dot)com

You cant insert into a serial as far as I know.

The serial is simply incrimented automatically whenever a new INSERT is done
on the table.

~Michael (another one)