...

Hello,

I have a [beginner] question.  I found the following in mailing
list archives as a proposal and I was wondering if/when the following
will be available, or if there is a way to do this in current pg version:

> > 1) An imaginary field in every tuple that tells you the class it came
> > from.
> > This is useful when you select from table* and want to know which
> > relation the object actually came from. It wouldn't be stored on disk,
> > and like oid it wouldn't be displayed when you do SELECT *. The field
> > would be called classname. So you could have...
> > SELECT p.classname, p.name FROM person p;
> > person   | Fred
> > student  | Bill
> > employee | Jim
> > person   | Chris

I'm planning on switching from relational to object-relational model, and
a "select * from parent*" is really cool - except I need to know where
each element came from.  Of course I could always add an extra field and
store element's type in it but that'd be a waste of space, considering
that information is theoretically available to the backend.

Thanks,
-Vitaliy


--
Email: vitaliyf@gameaholic.com
ICQ: 1691002
http://www.gameaholic.com - Gameaholic dot Com