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

Question

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!

Answer 1

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.