zf2 表网关中的 postgresql 返回

Question

如何在通过表网关插入时添加 RETURNING 子句？

INSERT INTO users (name, age) VALUES ('Liszt', 10) RETURNING id;

Answer 1

$dataArray = array('name'=> 'Liszt','age' => 10);
$this->tableGateway->insert($dataArray);
$userId = $this->tableGateway->lastInsertValue; 

另一种方法是:

$userId = $this->tableGateway->getLastInsertValue();