Primary Key

From: Eduardo V(dot) Rodríguez <evazquez(at)insys-corp(dot)com(dot)mx>
To: "Postgres (E-mail)" <pgsql-novice(at)postgresql(dot)org>
Subject: Primary Key
Date: 2004-06-15 00:17:37
Message-ID: 59B41C14544D314889E6FA384A307A921C90B4@osiris.insys-corp.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mike G 2004-06-15 04:34:56 Re: Primary Key
Previous Message jarednevans 2004-06-14 17:50:05 benefits of an Array Column?