create view ... select fld,'constant',fld ...
От | will trillich |
---|---|
Тема | create view ... select fld,'constant',fld ... |
Дата | |
Msg-id | 20030131235150.GA3459@mail.serensoft.com обсуждение исходный текст |
Ответы |
Re: create view ... select fld,'constant',fld ...
|
Список | 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/ !
В списке pgsql-general по дате отправления: