Received: from onyx.floppy.org (ONyx.Floppy.ORG [195.222.226.249]) by hub.org (8.8.8/8.8.8) with SMTP id KAA18739 for ; Tue, 6 Oct 1998 10:03:32 -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) ; Tue, 6 Oct 1998 16:03:31 +0100 Message-Id: <199810061603.3142469.6@onyx.floppy.org> From: "Gemeinschaft Studienarbeit Datenbanken" To: "PostgreSQL SQL Mailing List" Cc: "Datenbanksysteme Studienarbeit" Date: Tue, 06 Oct 1998 16:03:30 +0100 Reply-To: "Gemeinschaft Studienarbeit Datenbanken" Priority: Normal X-Mailer: PMMail 1.96a For OS/2 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Subject: select-querries out of an array? Hiho, I have a question which neither the samples (as far as I was able to figure out) or the documentation were able to clear up. I have a table definition like (btw. why isn't the primary key of the Spiel-class inherited by the children classes???) create table Spiel ( Name text not null, Bestellnummer text not null primary key, HerstellerID int4 not null, Erscheinungsdatum datetime, Preisempfehlung money not null, Beschreibung text[], Computertyp text[] not null, Datentraegertyp text[] not null, ClueBook text[] ); create table rollenspiel ( Bestellnummer text not null primary key, System text not null, AnzahlCharaktere int2 not null, Typ text not null, SpielstandEditor text[] ) inherits ( spiel ); create table adventure ( Bestellnummer text not null primary key, Schwierigkeitsgrad int2 not null ) inherits ( spiel ); create table simulation ( Bestellnummer text not null primary key, Typ text[] not null, AnzahlChars int2 not null ) inherits ( spiel ); create table action ( Bestellnummer text not null primary key, Eingabegeraet text[] not null, AnzahlSpieler int2 not null ) inherits ( spiel ); with several subclasses which inherit attributes from the parent class. When I now would like to have all games (Spiel*) selected, which come on CD as media (Datentraegertyp is array which contains CD, Disks, misc, etc.), I would type the sql request like this: select name from Spiel* where Datentraegertyp = '{"CD"}'; which only lists all games which *ONLY* come on CD (pretty clear as the match is '=' on the single array entry. How do I formulate the request when I would like to have those which have Datentraegertyp like '{"CD", "Diskette"}' or '{"Tape", "Diskette", "CD"}' ? I hope you get what I am up to ;-) Thanks once again for hints.