unique index on variable time

From: "pgsql-general(at)list(dot)coretech(dot)ro" <pgsql-general(at)list(dot)coretech(dot)ro>
To: pgsql-general(at)postgresql(dot)org
Subject: unique index on variable time
Date: 2006-04-16 16:07:11
Message-ID: 44426BAF.4070703@list.coretech.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


hello,

I am interested to know if I can define an unique index on a timestamp
column to reject values within one hour.

insert into table(timestamp_col) values(LOCALTIMESTAMP);
insert into table(timestamp_col) values(LOCALTIMESTAMP + '5
minutes'::INTERVAL);
I want the second insert to fail with "unique violation".

is it possible to do something like that ? I am not interested in
"date_trunc" because I want it to work and for minute 59.

thanks,
Razvan Radu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pgsql-general@list.coretech.ro 2006-04-16 16:24:15 inet value validation
Previous Message Yeye 2006-04-16 02:49:37 Help about physical page layout in PostgreSQL: