Re: [GENERAL] Classes of returned rows

2001-04-26 Thread Jeff Waugh
> Use the "tableoid" pseudo-column. Ah! Awesome. A little playing with pg_class, and we have table/class names too. PostgreSQL has cool new things to find every day... Thanks Tom! - Jeff -- Web development with PHP is like injecting pure rust with a hig

[GENERAL] Classes of returned rows

2001-04-26 Thread Jeff Waugh
Hi all, Is there a way of determining the original class of a row when querying inherited tables? Consider: CREATE TABLE users ( uid int4 SERIAL PRIMARY KEY, email varchar(60) ); CREATE TABLE clients ( surname varchar(30) [etc] ) INHERITS (users); CREATE TABLE suppliers (