Search inherited tables - Mailing list pgsql-general

From Stephan Richter
Subject Search inherited tables
Date
Msg-id 4.3.1.0.20000909091244.00a8c4c0@198.78.130.6
Whole thread Raw
List 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


pgsql-general by date:

Previous
From: Samy Elashmawy
Date:
Subject: Re: Reports
Next
From: Stephan Richter
Date:
Subject: Another question: Order of entries