Postgres pq - LastInsertId

[zeroc8]

Has anyone been successful getting the LastInsertId after an insert statement?

When I try to read LastInsertId() from result, I get
"pq: this is postgres, a real database, this isn't a valid command".

Fair enough, but Postgres has something like this
insert into foo values('bla') return id

Is there any way to retrieve that value?

[Alexander Neumann]

Try something like this (untested):

err := db.QueryRow("INSERT INTO foo (bar) VALUES ($1) RETURNING id;",
bar).Scan(&id)

[zeroc8]

Am Dienstag, 8. Mai 2012 11:19:13 UTC+2 schrieb Alexander Neumann:

Try something like this (untested):

err := db.QueryRow("INSERT INTO foo (bar) VALUES ($1) RETURNING id;",
bar).Scan(&id)

Thanks, works.
err := tx.QueryRow("insert into car(name) values($1) returning id","test").Scan(&id)
   
 

[zeroc8]

[Justin Wilson]

Just what I was looking for too, thanks =)

[Arne Hormann]

I never used the pg driver, but why don't you use Exec instead of Query? Exec returns sql.Result, which has a method LastInsertId().

[notedit]

the pg driver's  sql.Result does not return lastinsertid.

err := db.QueryRow("INSERT INTO foo (bar) VALUES ($1) RETURNING id;",
bar).Scan(&id)

this will have another question, if the insert has some error, it will return some like "no result error".

2013/7/10 Arne Hormann <arneh...@gmail.com>

I never used the pg driver, but why don't you use Exec instead of Query? Exec returns sql.Result, which has a method LastInsertId().

--
You received this message because you are subscribed to the Google Groups "golang-nuts" group.
To unsubscribe from this group and stop receiving emails from it, send an email to golang-nuts...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Kamil Kisiel]

Postgres by default does not return the last inserted id unless you explicitly ask for it with the RETURNING clause. However the fields returned by the clause can be arbitrarily specified, so there's no way to identify a single id without knowledge of the schema and query.

See http://www.postgresql.org/docs/9.2/static/sql-insert.html