From: | "Gemeinschaft Studienarbeit Datenbanken" <oodbms(at)floppy(dot)org> |
---|---|
To: | "PostgreSQL SQL Mailing List" <pgsql-sql(at)hub(dot)org> |
Cc: | "Datenbanksysteme Studienarbeit" <oodbms(at)floppy(dot)org> |
Subject: | Updates/Deletes on class* |
Date: | 1998-10-07 22:05:05 |
Message-ID: | 199810080005.0843094.6@onyx.floppy.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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,
From | Date | Subject | |
---|---|---|---|
Next Message | bisheng | 1998-10-08 05:04:37 | |
Previous Message | Giovanni Giuffrida | 1998-10-07 19:59:17 | CASE...WHEN... END |