Received: from vpcit.ru (qmailr@dialup.vpcit.ru [195.38.52.246]) by hub.org (8.9.3/8.9.3) with SMTP id AAA65694 for ; Thu, 22 Jul 1999 00:21:25 -0400 (EDT) (envelope-from yura@vpcit.ru) Received: (qmail 762 invoked from network); 22 Jul 1999 04:21:22 -0000 Received: from gercon.vpcit.ru (HELO vpcit.ru) (195.38.52.226) by dialup.vpcit.ru with SMTP; 22 Jul 1999 04:21:22 -0000 Message-ID: <37969C56.ADFC172B@vpcit.ru> Date: Thu, 22 Jul 1999 10:21:42 +0600 From: Don Yury X-Mailer: Mozilla 4.61 [en] (Win98; I) X-Accept-Language: ru,en MIME-Version: 1.0 To: pgsql-sql@hub.org Subject: how to determine table? Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit Hi All. Suppose I do select from class with all subclasses, for example SELECT id, name FROM TAB* and I get something like id | name --------- 1 | n1 2 | n2 3 | n3 ... Then I want to know about certain record name of table where this record is stored, for example I want to know in which table record (2, n2). How I can do this? I guess I can add field 'tablename' to every subclass of tab class and fill it with certain table name in trigger, but perhaps exists more easy way? Sincerely yours, Yury. don.web-page.net, ICQ 11831432