What's the best way to do this in postgres? (basicly finding the type of
I want to run a web site with different types of content - question and
answers, stories etc. I propose an object hierarchy...
webobject (title, body)
question inherits webobject
story (image) inherits (webobject).
The idea being you could have a search screen that searches questions
AND stories with the one SELECT query.
But then each result would have a link to examine the body of the search
result. But different types of objects would have different URLs to
display that content.
So basicly I need to know the type of objects returned.
I am loath to store the object type inside the object because it is
wasteful. PG obviously already knows the type of objects, the question
is how to get at that info.
In response to
pgsql-general by date
|Next:||From: listuser||Date: 1999-04-21 06:00:20|
|Subject: XML objects in Postgres|
|Previous:||From: AGRE Enterprises Limited||Date: 1999-04-21 04:05:55|
|Subject: Default table structure|