Creating Static array in stored procedure in 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!

have tried this many times but still not working. Hence created this — shruti
– shruti, Commented Feb 22, 2016 at 8:56

shruti · Accepted Answer · 2016-02-22 10:43:40Z

4

Got the answer by my own

pArTriggerIds := ARRAY[CArTrigger::PRE_QUALIFICATION];

worked perfect for me with ar_trigger_id = ANY ( pArTriggerIds )

Thanks

answered Feb 22, 2016 at 10:43

shruti

7909 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shruti Kulkarni · Accepted Answer · 2016-02-23 04:49:04Z

3

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.

answered Feb 23, 2016 at 4:49

Shruti Kulkarni

464 bronze badges

Collectives™ on Stack Overflow

Creating Static array in stored procedure in postgresql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related