From: | "Francois TETE" <francois(dot)tete(at)stream-core(dot)com> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Inheritance and update |
Date: | 1999-03-29 08:42:05 |
Message-ID: | 01be79c0$06357140$070010ac@ft.gennevilliers.stream-core.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Is it possible to update rows in a derived class via the base class ?
I have a base class, let's say BASE and two derived tables DERIVED1 and
DERIVED2.
Suppose that select * from DERIVED1; returns :
id | name
1 | joe
and select * from DERIVED2; returns :
id | name
2 | bill
So select * from BASE*; returns as expected
id | name
1 | joe
2 | bill
But I can't update the tables using the following query :
update BASE* set name='john' where id=1;
Is there another means to do such an update ?
Thank you for any answer.
Francois
---
Francois TETE
StreamCORE
2 place des Hauts Tilliers - 92632 Gennevilliers Cedex - France
Mail : francois(dot)tete(at)stream-core(dot)com
Phone: +33 1 41 21 46 22
Fax : +33 1 41 21 46 27
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 1999-03-29 10:34:14 | Re: [GENERAL] Determining if "in a text set" |
Previous Message | Francois TETE | 1999-03-29 08:41:32 | Inheritance and selection |