Classes of returned rows

Поиск
Список
Период
Сортировка
От Jeff Waugh
Тема Classes of returned rows
Дата
Msg-id 20010425175408.I421@aphid.net
обсуждение исходный текст
Ответы Re: Classes of returned rows  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Classes of returned rows  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-general
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 (
    surname varchar(30)
    [etc]
) INHERITS (users);


Then, when I execute "SELECT * FROM users", I'd like to know which classes
each row belongs to, ie. suppliers, clients or users. Hopefully, as easy as
"SELECT oid, * FROM users" is!

I'm using 7.1 already, and it kicks arse. Many thanks to pgsql-hackers for a
wonderful piece of software I use every day. Thanks. :)

- Jeff

--
       "Can we have a special TELSABUG category, and everything gets
                 dropped to fix them first?" - Telsa Gwynne

В списке pgsql-general по дате отправления:

Предыдущее
От: Theo van der Sluijs
Дата:
Сообщение: state locked row (PLEASE HELP ME)
Следующее
От: "Wendy"
Дата:
Сообщение: Why Size Of Data Backed Up Varies Significantly In SQL 6.5?