create view ... select fld,'constant',fld ... - Mailing list 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/ !