pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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,







Message-ID: <199810080005.0843094.6@onyx.floppy.org>
Permalink:  ../199810080005.0843094.6@onyx.floppy.org/
Also on:    postgresql.org/message-id/199810080005.0843094.6@onyx.floppy.org

 · 

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: 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