Common Table Expressions (With) And Cactiverecord.

Yii 1.1 General Discussion
1

hi,

Is it possible to use Common Table Expressions (WITH) and a CActiveRecord?

Like:




WITH t1 as (UPDATE counter SET num=num+1 returning num) INSERT INTO t2 (sometextvalue, counter_num) VALUES ('some text', (SELECT num FROM t1));

Link to WITH: WITH

Thanks.

2

Interested to know, too. But judging from the age of Yii1 and the CTE specification it does not seem like a out of the box solution.

Maybe using Yii2 along with Yii1 is easier to do so.