From: Gemeinschaft Studienarbeit Datenbanken <oodbms@floppy.org>
To: PostgreSQL SQL Mailing List <pgsql-sql@hub.org>
Cc: Datenbanksysteme Studienarbeit <oodbms@floppy.org>
Subject: Updates/Deletes on class*
Date: Thu, 08 Oct 1998 00:05:05 +0200 (DST)
Message-ID: <199810080005.0843094.6@onyx.floppy.org> (raw)
Hi,
(yeah, its us again ;-)
(the background: we are doing a research work on ORDBMS and Postgres
is the only one *THERE* *working*. Thats why we have that many and
different questions which seem for a couple of people senseless (not
excluding ourselves, that is ;-) ).
ok, here we go again:
1) update Personen* set Name = 'LucasArts' where Name like '%LucasArts%';
results in Parser Error near *.
2) <probably same reason>
delete from Personen*;
results in Parser Error near *.
AFAIK the documentation claims it should work (if I am not wrong here).
The question: are we using a wrong syntax or isn't it implemented (yet)?
Further
3) select producerid from producer where name like '%IBM%';
yields the "8" as int4 as result.
doing then a
select name from game* where producerid = 8;
yields all four resulting entries, three in class game itself, one in
a child class of game.
BUT:
select name from game* where producerid = ( select producerid from producer
where name like '%IBM%' );
yields only *3* results, the three in class game itself, not in the child class.
Why?
OK, thats all for now and once again thanks for the help we received sofar 8))
Greetings,
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: oodbms@floppy.org, pgsql-sql@hub.org
Subject: Re: Updates/Deletes on class*
In-Reply-To: <199810080005.0843094.6@onyx.floppy.org>
References: <199810080005.0843094.6@onyx.floppy.org>
* 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