4 CREATE OR REPLACE FUNCTION itemprice_wrp(integer, integer)
10 i_itemsite_id ALIAS FOR $1;
11 i_curr_id ALIAS FOR $2;
12 v_result numeric(18, 6);
19 ROUND(MAX(ipsitem_price),3)
27 ipshead_id = ipsitem_ipshead_id
31 ipsitem_item_id = itemsite_item_id
33 ipshead_name like '%WRP%'
35 ipshead_curr_id = i_curr_id
37 itemsite_id = i_itemsite_id;
40 IF FOUND AND v_result IS NOT NULL THEN
47 -- default... could not work it out above..
49 -- use the list price.
64 item_id = itemsite_item_id
66 itemsite_id = i_itemsite_id
75 LANGUAGE plpgsql VOLATILE
78 ALTER FUNCTION itemprice_wrp(integer, integer)
82 -- select itemprice_wrp(itemsite_id, getcurrid('USD')) FROM itemsite;