Suppose I have table a and b (b inherits a).

Then I do select * from a*;

Now, I'd like to know which table this particular row came from (a or b).
Is this possible? Or do I have to have a column where I'd store what kind
of object this is?

-alex


Sat, 7 Oct 2000 19:51:38 -0400 (EDT)
Alex Pilosov <alex@pilosoft.com>
inheritance/oid questions
In the up and coming version of postgres there will be a special column
called "tableoid" which gives the oid from pg_class of the table it came
from. If you are not using the current CVS sources, you will have to
keep a column updated yourself.

Alex Pilosov wrote:
> 
> Suppose I have table a and b (b inherits a).
> 
> Then I do select * from a*;
> 
> Now, I'd like to know which table this particular row came from (a or b).
> Is this possible? Or do I have to have a column where I'd store what kind
> of object this is?
> 
> -alex

-- 
Chris Bitmead
mailto:chris@bitmead.com
http://www.techphoto.org - Photography News, Stuff that Matters

Sun, 08 Oct 2000 21:54:21 +1100
Chris <chris@bitmead.com>
Re: inheritance/oid questions