Object-oriented stuff and postgres
| От | Chris Bitmead |
|---|---|
| Тема | Object-oriented stuff and postgres |
| Дата | |
| Msg-id | 371D632B.9CD109B4@bigfoot.com обсуждение исходный текст |
| Ответ на | Re: [GENERAL] How to get seq after insert] (Bruce Momjian <maillist@candle.pha.pa.us>) |
| Список | 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.
В списке pgsql-general по дате отправления: