pq: invalid input syntax for type integer

[Ghada-Emad1]

func (m *SnippetModel) Insert(title string, content string, expires int) (int, error) {
	var pk int
	err := m.DB.QueryRow(`INSERT INTO snippets VALUES($1,$2,$3) RETURNING id`, title, content, expires).Scan(&pk)
	if err != nil {
		return 0, err
	}

	return pk, nil
}

i want to return last index has been inserted into db

func (app *Application) snippetCreate(w http.ResponseWriter, r *http.Request) {
	if r.Method != http.MethodPost {
		w.Header().Set("Allow", "Post")
		app.ClientError(w, http.StatusMethodNotAllowed)
		return
	}

	title := "O snail"
	content := "O snail\nClimb Mount Fuji,\nBut slowly, slowly!\n\n– Kobayashi Issa"
	expires := 7
	
	id, err := app.snippets.Insert(title, content, expires)
	if err != nil {
		app.ServeError(w, err)
		return
	}

	// Redirect the user to the relevant page for the snippet.
	http.Redirect(w, r, fmt.Sprintf("/snippet/view?id=%d", id), http.StatusSeeOther)
}

but it always gives me that error

[iwanofski]

Your INSERT query needs columns. Try updating 2nd line in Insert func to:

err := m.DB.QueryRow(`INSERT INTO snippets (title, content, expires) VALUES ($1,$2,$3) RETURNING id`, title, content, expires).Scan(&pk)

[Ghada-Emad1]

thanks for your response ,i finally solved that dummy error