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
Дата:
FAQ