uniquely indexing Celko's nested set model - Mailing list pgsql-general

From Richard Broersma Jr
Subject uniquely indexing Celko's nested set model
Date
Msg-id 173427.67550.qm@web31803.mail.mud.yahoo.com
Whole thread Raw
Responses Re: uniquely indexing Celko's nested set model
Re: uniquely indexing Celko's nested set model
Re: uniquely indexing Celko's nested set model
List 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
toensure for all LEFTs and RIGHTs in a table, that is it is impossible for any LEFT or RIGHT to have to same value. 

pgsql-general by date:

Previous
From: "Josi Perez"
Date:
Subject: install failed with "not NTFS filesystem"
Next
From: Ralph Smith
Date:
Subject: Re: ERROR: Could not access status of transaction ####