"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])

Reply via email to