Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: unique index on variable time
- From: Michael Fuhr <mike(at)fuhr(dot)org>
- To: "pgsql-general(at)list(dot)coretech(dot)ro" <pgsql-general(at)list(dot)coretech(dot)ro>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: unique index on variable time
- Date: Sun, 16 Apr 2006 10:50:26 -0600
- Message-id: <20060416165025(dot)GA33828(at)winnie(dot)fuhr(dot)org>
On Sun, Apr 16, 2006 at 07:07:11PM +0300, pgsql-general(at)list(dot)coretech(dot)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
- Follow-Ups:
- Re: unique index on variable time
- From: Tom Lane
- Re: unique index on variable time
- References:
- unique index on variable time
- From: pgsql-general(at)list(dot)coretech(dot)ro
- unique index on variable time
- Prev by Date: Query runs fast or slow
- Next by Date: Re: inet value validation
- Previous by thread: unique index on variable time
- Next by thread: Re: unique index on variable time
- Indexes: