doumisha5081
doumisha5081
2016-02-22 05:59

在postgresql中的存储过程中创建静态数组

已采纳

I need to write below PHP code in stored procedure

$arrintArTriggerIds = array();

if( CApplicationStage::PRE_QUALIFICATION == $this->getAdo()->m_objApplication->getApplicationStageId() && CApplicationStatus::APPROVED == $this->getAdo()->m_objApplication->getApplicationStatusId() ) {

    $arrintArTriggerIds = array( CArTrigger::PRE_QUALIFICATION );

}

And I need to pass this $arrintArTriggerIds array to select query with where conditions.
This array may contain values like ar_trigger_id IN (102, 103) etc.

Please help me with this. Thanks in advance!

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

2条回答

  • dsnnvpobaljihv3490 dsnnvpobaljihv3490 5年前

    Try using @ with variable name:

    declare @MonthsSale table(monthnr int)
    insert into @MonthsSale (monthnr) values (1)
    insert into @MonthsSale (monthnr) values (2)
    

    AND you can also get records like

    SELECT month_id FROM @MonthsSale; 
    

    Thanks.

    点赞 评论 复制链接分享
  • dongling2038 dongling2038 5年前

    Got the answer by my own

    pArTriggerIds := ARRAY[CArTrigger::PRE_QUALIFICATION];
    

    worked perfect for me with ar_trigger_id = ANY ( pArTriggerIds )

    Thanks

    点赞 评论 复制链接分享

相关推荐