Re: [GENERAL] data type "serial"

If you have this table:

create table testing (
    id    serial,
    data    text,
    md    int
);

You would use:

insert into testing (data, md) values ('my_data', 12);
insert into testing (data, md) values ('more data', 15);

The key part is that you don't specify the serial field in your insert command.

Anyway, hope this helps.


At 09:45 PM 9/22/99, Michael wrote:
>> >
>> > 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@bizsystems.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.
>
>Hmmm.... that's a real problem when adding it to an existing table.
>The values I get back on a select indicate all blanks. I've got
>several hundred records in the table at the moment. There must be a
>way to update the darn things.
>
>Michael
>Michael@bizsystems.com
>
>************
>