Object-oriented stuff and postgres

From: Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Object-oriented stuff and postgres
Date: 1999-04-21 05:33:32
Message-ID: 371D632B.9CD109B4@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What's the best way to do this in postgres? (basicly finding the type of
objects).

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message listuser 1999-04-21 06:00:20 XML objects in Postgres
Previous Message AGRE Enterprises Limited 1999-04-21 04:05:55 Default table structure