create view ... select fld,'constant',fld ...

Поиск
Список
Период
Сортировка
От will trillich
Тема create view ... select fld,'constant',fld ...
Дата
Msg-id 20030131235150.GA3459@mail.serensoft.com
обсуждение исходный текст
Ответы Re: create view ... select fld,'constant',fld ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
is this a stupid idea?

    create table _kid (
        id serial,
        datum varchar(80),
        other bigint,
        -- many-to-one, kid-to-papa relation
        parent int4 references papa(id)
    );

    create view kid as
    select
        id,
        datum,
        other,
        parent,
        -- which table is our parent? right here:
        'papa' as parent_table
    from
        _kid;

then we can do things like

    ->execute("select parent_table from $table")

but is it a performance-sucker? or bandwidth-killer? or just
all-round horrid idea?

or not?

--
There are 10 kinds of people:
ones that get binary, and ones that don't.

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

Looking for a firewall? Do you think smoothwall sucks? You're
probably right... Try the folks at http://clarkconnect.org/ !

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

Предыдущее
От: "Williams, Travis L, NPONS"
Дата:
Сообщение: Re: grant to all tables
Следующее
От: Sean Chittenden
Дата:
Сообщение: Re: Status of tablespaces