pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / 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