Call Postgresql functions

Yii 2.0 General Discussions
1

hello

How I can call or use postgresql functions in yii 2?

2

In database, postgresql function:

CREATE OR REPLACE FUNCTION concat_text(text, text)

RETURNS text AS

$BODY$

BEGIN


    RETURN $1 || $2;


END;

$BODY$

LANGUAGE plpgsql VOLATILE

COST 100;

In controller:


public function actionConcat_text() {

        $command = Yii::$app->db->createCommand("SELECT concat_text('conn', 'ected')");

        $data = $command->query();

        foreach ($data as $d) {

            $arr[] = implode("", $d);

        }

        return $this->render('display_txt', [

            'arr' => $arr[0],

        ]);

}

Test it in display_txt.php file in ‘view’ folder:


<?php

     echo $arr;    

?>
3

That worked

thanks…