Quick Links

uniquely indexing Celko's nested set model

From:	Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To:	General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject:	uniquely indexing Celko's nested set model
Date:	2007-10-19 21:42:03
Message-ID:	173427.67550.qm@web31803.mail.mud.yahoo.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Is it possible to constraint both the LEFT and RIGHT fields of a record to use the same index? I am looking for a way to ensure for all LEFTs and RIGHTs in a table, that is it is impossible for any LEFT or RIGHT to have to same value.

Responses

Re: uniquely indexing Celko's nested set model at 2007-10-20 02:37:56 from Scott Marlowe
Re: uniquely indexing Celko's nested set model at 2007-10-20 03:15:45 from Michael Glaesemann
Re: uniquely indexing Celko's nested set model at 2007-10-20 12:33:17 from Merlin Moncure

Browse pgsql-general by date

	From	Date	Subject
Next Message	Valerie Cole	2007-10-19 22:03:35	Question regarding Hibernate ORDER BY issue
Previous Message	Josi Perez	2007-10-19 21:17:47	install failed with "not NTFS filesystem"