NosyMan wrote: > Can I set id_product from statement 1 to a variable and use that > variable into statements 2.
You can't do that in plain SQL, but perhaps you want to look into PL/pgSQL. Please don't post to pgsql-patches unless you have a patch. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq