See the data type "SERIAL" in the PostgreSQL manual for whatever flavor of the
database you are using ...
Apologies for top-posting -- challenged mail client.
HTH,
Greg W.
________________________________
From: Andre Lopes <lopes80an...@gmail.com>
To: pgsql-general@postgresql.org
Sent: Wed, December 2, 2009 2:52:51 PM
Subject: [GENERAL] How to auto-increment?
Hi,
I have a table like this:
id_product
id_increment
and I need to increment values in id_increment like this
prod_1
1
prod_1
2
prod_1
3
prod_2
1
Wich is the best way to do this? Using a trigger? Where can I find examples of
plpgsql doing this?
Best Regards, André.
Sorry for my bad english.
