how to implement unusual constraint
От
danmcb
Тема
how to implement unusual constraint
Дата
Msg-id
1182678897.876810.6330@n2g2000hse.googlegroups.com
Список
Дерево обсуждения
how to implement unusual constraint danmcb <danielmcbrearty@gmail.com>
Re: how to implement unusual constraint Ragnar <gnari@hive.is>
Re: how to implement unusual constraint Tom Lane <tgl@sss.pgh.pa.us>
Re: how to implement unusual constraint danmcb <danielmcbrearty@gmail.com>
Re: how to implement unusual constraint Andrew Sullivan <ajs@crankycanuck.ca>
Say I have a table, say my_table, that is self-referencing. It looks like this : id integer pk, orig_id integer references my_table(id), . . . Now this set of rows would be legal id/orig_id 1 /1 2/1 3/1 4/4 5/4 but this not: id/orig_id 1 /1 2/1 3/1 4/1 5/4 in other words: the row pointed to by orig_id cannot reference any row other than itself. How might I implement this as a constraint? thanks, Daniel
В списке pgsql-general по дате отправления
От: Ragnar
Дата:
От: carter ck
Дата: