Re: [SQL] Triggers to create Tables

Поиск
Список
Период
Сортировка
От tolik@icomm.ru (Anatoly K. Lasareff)
Тема Re: [SQL] Triggers to create Tables
Дата
Msg-id 87n2295njt.fsf@tolikus.hq.aaanet.ru
обсуждение исходный текст
Ответ на Triggers to create Tables  (Martin Möderndorfer <mmoedern@linux.stuco.uni-klu.ac.at>)
Список pgsql-sql
>>>>> "d" == derndorfer  <Martin> writes:

 d> hi,
 d> this is the part II of a question i already asked:

 d> i have some tables:
 d> create table css_class(nr int4, classname varchar(50));
 d> create table css_prop(nr int4, name varchar(50), val varchar(50),
 d> classnr int4);
 d> (css_prop.classnr foreign key-> css_class.nr)

 d> i would need a trigger on update and insert who takes all entries from
 d> the tables above and put them into a textfile in the following stype

 d> .n-th_of_css_class {
 d> n-th_of_css_prop.name(*) : n-th_of_css_prop.val(*);
 d> n+1-th_of_css_prop.name(*): [...]
 d> }
 d> .n+1-th_of_css_class { [...]

 d> with other words: i want to create a cascading style sheet out of the
 d> table:
 d> css files look something like that

 d> .cassname {
 d> property1 : value_prop1;
 d> property2 : value_prop2;
 d> [...]
 d> }
 d> [...]

 d> Can anyone help?
 d> a c-function would be ok too (_really_ think that i need one) but the
 d> file has to be created by the database itself.

 d> Idea for the future: whole html pages built out of the databased
 d> resulted by trigger/query combination. (not the question _yet_)

 d> MArtin

I think this is bad idea to build text file every time you change the
tables. What about external program (on C, Perl... etc) what rebuilds,
pehaps incrementally, file(s) with changed data? Or creating style
sheets and html pages 'on the fly' with any cgi-script?


--
Anatoly K. Lasareff              Email:       tolik@icomm.ru
Senior programmer

В списке pgsql-sql по дате отправления:

Предыдущее
От: tolik@icomm.ru (Anatoly K. Lasareff)
Дата:
Сообщение: Re: [SQL] problem with function in plpgsql
Следующее
От: Martin Möderndorfer
Дата:
Сообщение: Re: [SQL] Triggers to create Tables