pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
inheritance and update
2+ messages / 1 participants
[nested] [flat]

* inheritance and update
@ 1999-03-29 08:34 Francois TETE <francois.tete@stream-core.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Francois TETE @ 1999-03-29 08:34 UTC (permalink / raw)
  To: 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.tete@stream-core.com
  Phone: +33 1 41 21 46 22
  Fax  : +33 1 41 21 46 27

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Inheritance and update
@ 1999-03-29 08:42 Francois TETE <francois.tete@stream-core.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Francois TETE @ 1999-03-29 08:42 UTC (permalink / raw)
  To: 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.tete@stream-core.com
  Phone: +33 1 41 21 46 22
  Fax  : +33 1 41 21 46 27





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-03-29 08:42 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-03-29 08:34 inheritance and update Francois TETE <francois.tete@stream-core.com>
1999-03-29 08:42 Inheritance and update Francois TETE <francois.tete@stream-core.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox