Problem with insert
| От | Jerome Raupach |
|---|---|
| Тема | Problem with insert |
| Дата | |
| Msg-id | 39A3C8B4.D972C2B7@intelcom.fr обсуждение исходный текст |
| Ответы |
Re: Problem with insert
|
| Список | pgsql-hackers |
The query: INSERT INTO table_resultat( origine, service, noeud, rubrique, nb_passage, temps, date) SELECT DISTINCT temp2.origine, temp2.service, temp2.noeud, temp2.rubrique, temp2.nb_passage, temp2.temps, temp2.date FROM temp2 WHERE not exists ( SELECT table_resultat.origine, table_resultat.service, table_resultat.noeud, table_resultat.rubrique, table_resultat.date FROM table_brut WHERE table_resultat.origine=temp2.origine AND table_resultat.service=temp2.service AND table_resultat.noeud=temp2.noeud AND table_resultat.rubrique=temp2.rubrique AND table_resultat.date=temp2.date ) produces the error : ERROR: replace_vars_with_subplan_refs: variable not in subplan target list anyone can explain me ? Thanks. Jerome.
В списке pgsql-hackers по дате отправления: