Search inherited tables

Stephan Richter <srichter@cbu.edu>

From: Stephan Richter <srichter@cbu.edu>
To: PGSQL General <pgsql-general@postgresql.org>
Date: 2000-09-09T14:18:03Z
Lists: pgsql-general
Hello everyone,

I have he following situation:

I have a 'base' table called Problem and 5 other tables that inherit 
Problem: MultipleChoiceProblem, TrueFalseProblem, EssayProblem, 
NumericProblem and MatchProblem

I want to do the following query:

SELECT * FROM Problem;

But Problem is empty, since I fill only the derived tables. How can I make 
this query?

Thanks for your help in advance!

Regards,
Stephan
--
Stephan Richter
CBU - Physics and Chemistry Student
Web2k - Web Design/Development & Technical Project Management