I have a table that will have a parent/child relationship (specifically a recursive collection of categories) and was wondering if I can reference a key in the same table ... CREATE TABLE categories ( categoryID integer PRIMARY KEY, parentID integer REFERENCES categories (categoryID) ON DELETE CASCADE, ... ); Is this supported? Any comments from people out there who have created such setups? I'm new to PGSQL and looking hard at converting from MySQL so all of these fun features are new to me :) Thanks! --Joe -- Joe Stump, President JCS Solutions http://www.jcssolutions.com (734) 786 0176 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
