Re: unique index on variable time - Mailing list pgsql-general

From Michael Fuhr
Subject Re: unique index on variable time
Date
Msg-id 20060416165025.GA33828@winnie.fuhr.org
Whole thread Raw
In response to unique index on variable time  ("pgsql-general@list.coretech.ro" <pgsql-general@list.coretech.ro>)
Responses Re: unique index on variable time  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Sun, Apr 16, 2006 at 07:07:11PM +0300, pgsql-general@list.coretech.ro wrote:
> I am interested to know if I can define an unique index on a timestamp
> column to reject values within one hour.

Last month I posted an idea for enforcing unique constraints on
date ranges by using a composite type and a custom comparison
operator:

http://archives.postgresql.org/pgsql-sql/2006-03/msg00055.php

The warning about the code being only minimally tested still stands
but maybe it'll give you some ideas.

--
Michael Fuhr

pgsql-general by date:

Previous
From: "pgsql-general@list.coretech.ro"
Date:
Subject: unique index on variable time
Next
From: Andreas Kretschmer
Date:
Subject: Re: inet value validation