Returning values partially in SQL returning array instead of object

[Jumaniyozov]

Hi, I have a following query in which I'm partially returning values:

-- name: CreateUser :one
INSERT INTO users (email, username, password, isactive, created_at, updated_at)
VALUES ($1, $2, $3, $4, $5, $6)
RETURNING (id, email, username, isactive, created_at, updated_at);

And returning in following way:

userCreated, err := controller.queries.CreateUser(cctx, userParams)
	if err != nil {
		controller.logger.Error(err.Error())
		return c.JSON(http.StatusBadRequest, err)
	}

return c.JSON(http.StatusOK, userCreated)

But in return receiving an array not an object. How can I get object? I also tried parsing it to custom struct but getting an error saying json: cannot unmarshal array into Go value of type domain.UserReturnDTO

[Jumaniyozov]

Hi, I have a following query in which I'm partially returning values:

-- name: CreateUser :one
INSERT INTO users (email, username, password, isactive, created_at, updated_at)
VALUES ($1, $2, $3, $4, $5, $6)
RETURNING (id, email, username, isactive, created_at, updated_at);

And returning in following way:

userCreated, err := controller.queries.CreateUser(cctx, userParams)
	if err != nil {
		controller.logger.Error(err.Error())
		return c.JSON(http.StatusBadRequest, err)
	}

return c.JSON(http.StatusOK, userCreated)

But in return receiving an array not an object. How can I get object? I also tried parsing it to custom struct but getting an error saying json: cannot unmarshal array into Go value of type domain.UserReturnDTO

I think it's because of generated code where as return value it's using interface{}