doumisha5081 2016-02-22 05:59
浏览 889
已采纳

在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 2016-02-23 04:49
    关注

    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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 手机应用的时间可以修改吗
  • ¥15 docker 运行OPEN-webui异常
  • ¥15 麒麟系统如何删除光盘刻录痕迹
  • ¥15 recipe通过gem协议传的是什么
  • ¥15 TS2307: Cannot find module 'cc'.
  • ¥15 100小时学会sap 书上pp章节5.22,标准成本计算逻辑?
  • ¥50 达梦数据库误删日志文件重做DAMENG01.log启动仍然-712错误
  • ¥15 cellranger化学处理类型报错
  • ¥15 用texstudio插入图片出现下面情况,怎么办
  • ¥15 ubantu 用samba挂载windows的共享文件夹,无法挂载二级目录和修改文件