Postgres Pro
Downloads
Home   >   mailing lists

Can I use variable to store sql data? - Mailing list pgsql-patches

From NosyMan
Subject Can I use variable to store sql data?
Date
Msg-id 200510170955.50217.nosyman@gmail.com
Whole thread Raw
In response to small typo  (Euler Taveira de Oliveira <eulerto@yahoo.com.br>)
List pgsql-patches
Tree view 
Hi,

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

Now I want to insert id_product into another table :

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

pgsql-patches by date:

Previous
From: NosyMan
Date:
Subject: Can I use variable to store sql data - II
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Patching dblink.c to avoid warning about