On Sunday 24. January 2010 14.43.10 Ovid wrote: > Assuming I have the following table: > > CREATE TABLE refers ( > id SERIAL PRIMARY KEY, > name VARCHAR(255) NOT NULL, > parent_id INTEGER NOT NULL, > FOREIGN KEY (parent_id) REFERENCES refers(id) > ); > I need to insert two records so that "select * from refers" looks like this: > > =# select * from refers; > id | name | parent_id > ----+------+----------- > 1 | xxxx | 1 > 2 | yyy | 2 > > The first record can't be inserted because I don't yet know the parent_id. I've got a similar structure. I just declared the root node with both id and parent_id=0. regards, -- Leif Biberg Kristensen http://solumslekt.org/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
