Home > mailing lists

How to auto-increment? - Mailing list pgsql-general

From	Andre Lopes
Subject	How to auto-increment?
Date	December 2, 2009 21:53:04
Msg-id	18f98e680912021452p70f33530x72c37f6268535601@mail.gmail.com Whole thread Raw
Responses	Re: How to auto-increment? (Greg Williamson <gwilliamson39@yahoo.com>) Re: How to auto-increment? (John R Pierce <pierce@hogranch.com>) Re: How to auto-increment? ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List	pgsql-general

Hi,

I have a table like this:

id_product

id_increment

and I need to increment values in id_increment like this

prod_1

prod_2

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.

From: Adrian Klaver
Date: 02 December 2009, 21:49:28
Subject: Re: Catastrophic changes to PostgreSQL 8.4

From: Greg Williamson
Date: 02 December 2009, 22:07:32
Subject: Re: How to auto-increment?