--- vamseelist(at)gmail(dot)com wrote:
> I mean d,e got 1 and 2 in mgr table.
> d,e got 4,5 in new table.
> I would like to replace 1 1 2 with 4 4 5.
> I would like to modify above table as
I would modify your manager and employees tables to look like:
CREATE TABLE Employees (
emp_id SERIAL PRIMARY KEY,
CREATE TABLE Managers (
mgr_id INTEGER PRIMARY KEY REFERENCES Employees( emp_id ));
ALTER TABLE Employees
ADD CONSTRAINT managers_of_employees
FOREIGN KEY ( mgr_id )
REFERENCES Managers( mgr_id );
Richard Broersma Jr.
In response to
pgsql-novice by date
|Next:||From: Angelica Garcia||Date: 2007-08-06 19:55:02|
|Subject: tree-like structures in pgsql|
|Previous:||From: vamseelist||Date: 2007-08-06 16:07:54|
|Subject: JOINING TWO TABLES|