X-Original-To: pgsql-php@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id B2437925DF5 for ; Sat, 31 May 2003 16:33:42 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 33301-07 for ; Sat, 31 May 2003 16:33:32 -0400 (EDT) Received: from debian (m192.net81-67-164.noos.fr [81.67.164.192]) by developer.postgresql.org (Postfix) with ESMTP id 1328692591C for ; Sat, 31 May 2003 16:33:32 -0400 (EDT) Received: from debian (debian [127.0.0.1]) by debian (Postfix) with ESMTP id 64C0110B72 for ; Sat, 31 May 2003 22:33:55 +0200 (CEST) From: pknoob To: pgsql-php@postgresql.org Subject: Inheritance issues displaying tables Date: Sat, 31 May 2003 22:33:54 +0200 User-Agent: KMail/1.5.1 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200305312233.54808.pknoob@noos.fr> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/59 X-Sequence-Number: 2064 I have three tables that look like this: CREATE TABLE episodes( id int, name text, ) ); CREATE TABLE p2p( p2p varchar ) INHERITS (episodes); CREATE TABLE irc( server_name varchar ) INHERITS (episodes); When I try : $squery="SELECT * FROM episodeirc,episodep2p"; $squery=pg_query($squery); while($row=pg_fetch_array($squery,NULL,PGSQL_ASSOC)) { echo " " . $row["name"] . " " . $row["id"] . " " . $row["p2p"] . " " . $row["server_name"] . "";} the problem is that it prints results from the episodep2p table only. how can I make it print results from both tables?