青云测评_Java开发_题目_JAVA

首页 > 知识中心 > Java开发 > AAA177

题目级别：工程师【适中】

您想更新订单表中最后修改的时间戳。当传递整数order_id参数时，在PL/pgSQL函数中的正确方法是：( )

备选答案

DECLARE
    order_id ALIAS FOR $1;
    mytimestamp timestamp;
  BEGIN
    mytimestamp := ''now'';
    UPDATE orders SET orderid=order_id, lastmodified = mytimestamp;
    RETURN mytimestamp;
  END;
' LANGUAGE 'plpgsql';

DECLARE
    order_id ALIAS FOR $1;
    mytimestamp timestamp;
  BEGIN
    mytimestamp := 'now';
    UPDATE orders SET orderid=order_id, lastmodified = mytimestamp;
    RETURN mytimestamp;
  END;
' LANGUAGE 'plpgsql';

DECLARE
    order_id ALIAS FOR $1;
  BEGIN
    mytimestamp := ''now'';
    UPDATE orders SET orderid=order_id, lastmodified = ''now'';
    RETURN mytimestamp;
  END;
' LANGUAGE 'plpgsql';

DECLARE
    order_id ALIAS FOR $1;
  BEGIN
    mytimestamp := ''now'';
    UPDATE orders SET orderid=order_id, lastmodified = 'now';
    RETURN mytimestamp;
  END;
' LANGUAGE 'plpgsql';