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: 20030131235150.GA3459@mail.serensoft.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group