Skip site navigation (1) Skip section navigation (2)

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: (view raw or whole 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
		-- which table is our parent? right here:
		'papa' as parent_table

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 -- we need your brain! -- your brain needs us!
Looking for a firewall? Do you think smoothwall sucks? You're
probably right... Try the folks at !


pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group