[SQL] problem with view in 7.3
Hi , I am Hristo Neshev From Bulgaria In Version 7.2 this statement works : create view v_impr_check(ead_no,ead_date, e_no,e_date,sid,number, s_order,cdt,cdt_description, original_qty,used_qty,waste_qty,rest_qty,original_used_qty)ASselect distinct md_custom_number, md_custom_date, md_number ,md_date ,sni_sid ,sni_number , snig_ord_number_in,cdt_part_number, cdt_description, snig_quantity,(select sum(impo_quantity) from impr_out where impo_store_note_in = snig_store_note_in and impo_ord_number_in = snig_ord_number_in),(select sum(impow_quantity) from impr_out_waste where impow_store_note_in= sni_sid and impow_ord_number_in = snig_ord_number_in),(select sum(iwnog_quantity) from impr_waste_note_out_goods where iwnog_store_note_in = sni_sid and iwnog_ord_number_in = snig_ord_number_in and iwnog_impr_note_out not in (select impow_iwnog_impr_note_out from impr_out_waste where impow_iwnog_impr_note_out is not null) ),snig_used_quantityfrom store_note_in join md_header on md_sni_sid = sni_sidjoin store_note_in_goods join commodity on (snig_commodity = cdt_sid) on sni_sid = snig_store_note_in Wheresni_type_doc = 303; In 7.3 when i am trying to recreate the view I received the folowing error : find_expr_references_walker: bogus varno 8 The problem is in subselect statements
[SQL] problem with view in 7.3
Hi , I am Hristo Neshev From Bulgaria In Version 7.2 this statement works : create view v_impr_check(ead_no,ead_date, e_no,e_date,sid,number, s_order,cdt,cdt_description, original_qty,used_qty,waste_qty,rest_qty,original_used_qty)ASselect distinct md_custom_number, md_custom_date, md_number ,md_date ,sni_sid ,sni_number , snig_ord_number_in,cdt_part_number, cdt_description, snig_quantity,(select sum(impo_quantity) from impr_out where impo_store_note_in = snig_store_note_in and impo_ord_number_in = snig_ord_number_in),(select sum(impow_quantity) from impr_out_waste where impow_store_note_in= sni_sid and impow_ord_number_in = snig_ord_number_in),(select sum(iwnog_quantity) from impr_waste_note_out_goods where iwnog_store_note_in = sni_sid and iwnog_ord_number_in = snig_ord_number_in and iwnog_impr_note_out not in (select impow_iwnog_impr_note_out from impr_out_waste where impow_iwnog_impr_note_out is not null) ),snig_used_quantityfrom store_note_in join md_header on md_sni_sid = sni_sidjoin store_note_in_goods join commodity on (snig_commodity = cdt_sid) on sni_sid = snig_store_note_in Wheresni_type_doc = 303; In 7.3 when i am trying to recreate the view I received the folowing error : find_expr_references_walker: bogus varno 8 The problem is in subselect statements
[SQL] Problem with view in PostgreSQl 7.3
I am sending a shema of used table. schema0.sql Description: Binary data ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
