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

From: will trillich <will(at)serensoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: create view ... select fld,'constant',fld ...
Date: 2003-01-31 23:51:50
Message-ID: 20030131235150.GA3459@mail.serensoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)serensoft(dot)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/ !

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sean Chittenden 2003-02-01 00:10:50 Re: Status of tablespaces
Previous Message Williams, Travis L, NPONS 2003-01-31 23:47:47 Re: grant to all tables