This may be a bit of stupid question but it is the first time i have
played around with rules and i am trying to convert a sql statement into
a rule
sample sql querty
INSERT INTO schema.table2
(
"field1",
"field2",
"field3",
"field4",
"field5",
"field6",
"field7",
"field8",
"field9",
)
VALUES
(
SELECT
table1."name",
table1.notes,
table1.hrs,
table1.days,
table3.value,
table31.value,
table4.ratename,
table4.maxhrs,
table4.appliesafter,
table4.rate,
table5.value,
table5."name"
FROM
(inner joins)
Where
primary = number
)
which i would like to make into a rule if possible
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
