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/ !
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 |