Thread

1. inheritance/oid questions

   alex@pilosoft.com — 2000-10-07T23:51:38Z

   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
   
   
   

2. Re: inheritance/oid questions

   Chris Bitmead <chris@bitmead.com> — 2000-10-08T10:54:21Z

   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