- Original Message -
From: Jim Newsham
To: 'Derby Discussion'
Sent: Wednesday, October 25, 2006 2:07 AM
Subject: RE: hierarchical table with unique constraint
As a workaround, I changed "generated" from "always" to "by default",
and
hear them.
Thanks,
Jim
From: Jim
Newsham [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 24, 2006 12:18
PMTo: 'Derby
Discussion'Subject:
hierarchical table with unique constraint
Hi,
Id like to create a hierarchical
table which r
,
Jim
From: Jim Newsham
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 24, 2006
12:18 PM
To: 'Derby Discussion'
Subject: hierarchical table with
unique constraint
Hi,
I’d like to create a hierarchical table which
references itself and enforces uniqueness. F
Hi,
I’d like to create a hierarchical table which
references itself and enforces uniqueness. For example:
create table node (
id int not null generated always as
identity primary key,
name varchar(32) not null,
fk_parent_id int,
