| From: | Jerome Raupach <jraupach(at)intelcom(dot)fr> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Problem with insert |
| Date: | 2000-08-23 12:51:00 |
| Message-ID: | 39A3C8B4.D972C2B7@intelcom.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 2000-08-23 13:36:43 | Re: minor comment fixes for ouiparse.awk |
| Previous Message | Larry Rosenman | 2000-08-23 12:45:59 | minor comment fixes for ouiparse.awk |