Received: from linux.stuco.uni-klu.ac.at (IDENT:qmailr@linux.stuco.uni-klu.ac.at [143.205.200.10]) by hub.org (8.9.2/8.9.1) with SMTP id MAA02480 for ; Fri, 19 Feb 1999 12:37:50 -0500 (EST) (envelope-from mmoedern@linux.stuco.uni-klu.ac.at) Received: (qmail 27992 invoked from network); 19 Feb 1999 17:37:36 -0000 Received: from kungfu.stuco.uni-klu.ac.at (HELO linux.stuco.uni-klu.ac.at) (143.205.200.98) by linux.stuco.uni-klu.ac.at with SMTP; 19 Feb 1999 17:37:36 -0000 Message-ID: <36CDA175.C0710662@linux.stuco.uni-klu.ac.at> Date: Fri, 19 Feb 1999 18:37:57 +0100 From: Martin =?iso-8859-1?Q?M=F6derndorfer?= Organization: IMAF Branch Austria X-Mailer: Mozilla 4.5 [en] (Win95; I) X-Accept-Language: de-AT,en,ja MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Triggers to create Tables Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit hi, this is the part II of a question i already asked: i have some tables: create table css_class(nr int4, classname varchar(50)); create table css_prop(nr int4, name varchar(50), val varchar(50), classnr int4); (css_prop.classnr foreign key-> css_class.nr) i would need a trigger on update and insert who takes all entries from the tables above and put them into a textfile in the following stype .n-th_of_css_class { n-th_of_css_prop.name(*) : n-th_of_css_prop.val(*); n+1-th_of_css_prop.name(*): [...] } .n+1-th_of_css_class { [...] with other words: i want to create a cascading style sheet out of the table: css files look something like that .cassname { property1 : value_prop1; property2 : value_prop2; [...] } [...] Can anyone help? a c-function would be ok too (_really_ think that i need one) but the file has to be created by the database itself. Idea for the future: whole html pages built out of the databased resulted by trigger/query combination. (not the question _yet_) MArtin