I have product tree for a product
product_tree table :
product_code, stock_code, amount_ratio
152.001.001, 151.001.001, 1
152.001.001, 150.001.001, 2
151.001.001 150.003.003, 3
151.001.001 150.009.001, 1
I need to write a query with result:
152.001.001, 150.003.003, 1
152.001.001, 150.
I solved the problem as
select * from MYFUNC();
instead of
select MYFUNC();
From: "devil live" <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: [SQL] Problem with Temp Table and Result Set from PL Function...
Date: Wed, 21 Feb 2007 11:31:02 +
When I run fo
When I run following Function with the following SETOF table...
it says:
NOTICE: table "temp_production_product_operations" does not exist, skipping
CONTEXT: SQL statement "drop table if exists
temp_production_product_operations "
PL/pgSQL function "pb_report_temp_gerceklesme12" line 11 at
I want to write sql statement about product, product_tree_special,
product_tree_template
product has
product_code varchar(20) PRIMARY KEY,
product_name varchar(20)
product_tree_template has
product_code varchar(20) PK,
stock_code_to_make_product(20) PK,
amout float4
product_tree_spci
