Re: Primary Key

If you want to use a primary key that increase in value by one each time consider using a sequence.

See http://www.postgresql.org/docs/7.4/static/sql-createsequence.html

On Mon, Jun 14, 2004 at 07:17:37PM -0500, Eduardo V. Rodríguez wrote:
> Hi
>
> I try to do the following in a table that has 4 columns,
>
> id - month - day- time
>
> The column id is the primary key, for example
>
> id - month . day - time
> 1    Jan          22   16:15
> 2    Jan       22   16:16
> 3    Jan       22   16:17
> 4    Jan       22   16:18
>
> But I pretend that automatically when I made an INSERT INTO table (month,
> day, time) values (A,B,C) the primary key update his value increasing by one
>
>
> I dont know how to do this, Iam using Postgres 7.4 with PgAdminIII
>
> Thank you
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend