-- Function: fn_order_add_delivery_address(integer, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying)

-- DROP FUNCTION fn_order_add_delivery_address(integer, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying);

CREATE OR REPLACE FUNCTION fn_order_add_delivery_address(integer, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying)
  RETURNS integer AS
$BODY$
DECLARE
            orderid                ALIAS for $1;
            firstname                 ALIAS for $2;
            surname                 ALIAS for $3;
            address1                 ALIAS for $4;
            address2                 ALIAS for $5;
            city                 ALIAS for $6;
            state                 ALIAS for $7;
            postcode                 ALIAS for $8;
            country                 ALIAS for $9;
            phone                 ALIAS for $10;
            email                 ALIAS for $11;

             insertid integer;
BEGIN

    INSERT INTO "order_shipp" ("n_order_id", "t_firstname", "t_surname", "t_address1", "t_address2", "t_city", "t_state", "t_postcode", "t_country", "t_phone", "t_email")
            VALUES (orderid, firstname, surname, address1, address2, city, state, postcode, country, phone, email);
            SELECT INTO insertid CURRVAL('order_shipp_n_id_seq');

        RETURN insertid;

END;$BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST 100;
ALTER FUNCTION fn_order_add_delivery_address(integer, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying) OWNER TO ookl;