[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

[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_nu

[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_n