rules
От | Jamie Deppeler |
---|---|
Тема | rules |
Дата | |
Msg-id | 41A6C088.2090507@doitonce.net.au обсуждение исходный текст |
Ответы |
Re: rules
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: