SEO

#1 (**permalink**) 04-17-2008, 11:59 PM

Hi,

The scenario:
1. SELECT id_product FROM products WHERE product_code='PRD-030';

Now I want to insert id_product into another table :

2. INSERT INTO product_sales( id_product, sale_date)
INSERT INTO product_sales( id_product, sale_date)
INSERT INTO product_sales( id_product, sale_date)

As you can see the 'id_product' is not known. I know one solution:
INSERT INTO product_sales( (SELECT id_product FROM products WHERE
product_code='PRD-030'), sale_date)
.... but I don't like it very mutch.

Can I set id_product from statement 1 to a variable and use that variable into
statements 2.

Thanks.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

#2 (**permalink**) 04-17-2008, 11:59 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Can I use variable to store sql data - II