rules

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

Предыдущее
От: felix@crowfix.com
Дата:
Сообщение: Re: off Topic: Looking for a good sql query
Следующее
От: Nikola Milutinovic
Дата:
Сообщение: PostgreSQL slow after VACUUM