← Prev in month ← Prev in thread
Next in thread → Next in month →

FK between rational and xml, between xml and xml

From
Dmitry Turin <>
To
Date
2007-11-05T13:22:23Z
ID
<>
Thread
FK between rational and xml, between xml and xml
Good day,

I propose to use XPath in DDL to create foreign keys
[1] from rational to xml

create table a(
  a1 num,
  a2 string
);
create table b(
  b1 num,
  b2 num references a(@a2/k/m/n/@n1)
);

[2] from xml to rational

create table a (
  a1 num,
  a2 num
);
create table b (
  b1 num,
  b2 string
);
alter table b add foreign key (@b2/k/m/n/@n1) references a(a2);

[3] from xml to xml

create table a (
  a1 num,
  a2 string
);
create table b (
  b1 num,
  b2 string
);
alter table b add foreign key (@b2/k/m/n/@n1) references a(@a2/p/q/r/@r1);



Dmitry Turin
SQL5      (5.7.0)  http://sql50.euro.ru
HTML6     (6.5.0)  http://html60.euro.ru
Unicode7  (7.2.1)  http://unicode70.euro.ru
Computer2 (2.0.2)  http://computer20.euro.ru
← Prev in month ← Prev in thread
Next in thread → Next in month →