Received: from onyx.floppy.org (ONyx.Floppy.ORG [195.222.226.249]) by hub.org (8.8.8/8.8.8) with SMTP id SAA09502 for ; Wed, 7 Oct 1998 18:05:11 -0400 (EDT) (envelope-from oodbms@floppy.org) Received: from onyx.floppy.org (onyx.floppy.org [195.222.226.249] ) by onyx.floppy.org (Hethmon Brothers Smtpd) ; Thu, 8 Oct 1998 00:05:07 +0100 Message-Id: <199810080005.0843094.6@onyx.floppy.org> From: "Gemeinschaft Studienarbeit Datenbanken" To: "PostgreSQL SQL Mailing List" Cc: "Datenbanksysteme Studienarbeit" Date: Thu, 08 Oct 1998 00:05:05 +0200 (DST) Reply-To: "Gemeinschaft Studienarbeit Datenbanken" Priority: Normal X-Mailer: PMMail 2.00.1500 for OS/2 Warp 4.00 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Subject: Updates/Deletes on class* 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) 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,