pgx is not returning rows after I do an insert

Asked Apr 09 '22 at 16:00

Active Apr 09 '22 at 16:00

Viewed 962 times

Im just doing an insert using the following code, and while i can see the data in the database, pgx is not returning any rows.

rows, err := db.Query(context.Background(), `
    INSERT INTO 
        reservation (room_id, user_id)
    VALUES 
        ($1, $2)
    `, roomId, userId)

I tried using QueryRow too but same thing, no rows are returned. Can anyone tell me where Im going wrong?

asked Apr 09 '22 at 16:00

discodowney

1,475
6
28
58

4

You need to add the `RETURNING` clause to the SQL string. See https://postgresql.org/docs/14/interactive/dml-returning.html for more details. – mkopriva Apr 09 '22 at 16:01
Cool. that did the trick. thanks – discodowney Apr 09 '22 at 16:36

pgx is not returning rows after I do an insert

0 Answers0