"Josué Maldonado" <[EMAIL PROTECTED]> wrote: > > El 13/08/2004 10:50 AM, [EMAIL PROTECTED] en su mensaje > escribio: > > ... > > insert into table1 (field1) values (1); > > insert into table1 (field1) values (1); > > insert into table1 (field1) values (2); > > > > and then select * from table1, you get: > > field1| field2 > > ------+------- > > 1 | 1 > > 1 | 2 > > 2 | 1 > > ------+------- > > > > there is a way to do this with postgres??? > > Check the serial data type.
I do not think this is possible with the serial data type in postgres. notice how the field2 is reset to 1 for each new value of field1 I did not know that this was possible in mysql. you would think that this is tricky to implement. gnari ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])