RETURNING clause in INSERT statements

[ghost]

It seems that Statement.Exec returns an empty Result instance with the LastInsertId and RowsAffected set explicitly to 0. Is there any chance to make this work with the RETURNING statement? E.g.:

res, err := db.Exec("INSERT INTO foo(a, b) VALUES(?, ?) RETURNING id", a, b)
...
_ = res.LastInsertId()

[nakagami]

Sorry LastInsertID() always return -1 (modified from return 0) beause Firebird can't return rowid

RowAffected() now return correct value (fixed)

[ghost]

Thanks. Firebird not returning the last insert id, is that a problem with protocol itself? Because this seems like it could potentially be a pretty big issue.

[nakagami]

OTH "insert .. returning ... "statement can get optional row value like select

https://github.com/nakagami/firebirdsql/blob/master/driver_test.go#L126

Regards

[ghost]

Aah. excellent. Thanks!