pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Francois TETE <francois.tete@stream-core.com>
To: pgsql-sql@postgresql.org
Subject: Inheritance and update
Date: Mon, 29 Mar 1999 10:42:05 +0200
Message-ID: <01be79c0$06357140$070010ac@ft.gennevilliers.stream-core.com> (raw)

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





view thread (2+ messages)

Message-ID: <01be79c0$06357140$070010ac@ft.gennevilliers.stream-core.com>
Permalink:  ../01be79c0$06357140$070010ac@ft.gennevilliers.stream-core.com/
Also on:    postgresql.org/message-id/01be79c0$06357140$070010ac@ft.gennevilliers.stream-core.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: francois.tete@stream-core.com
  Subject: Re: Inheritance and update
  In-Reply-To: <01be79c0$06357140$070010ac@ft.gennevilliers.stream-core.com>
  References: <01be79c0$06357140$070010ac@ft.gennevilliers.stream-core.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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