.Get()

[robfordww]

I have noticed that the.Get()method of Scany and Sqlx varies when you try to scan a select now() into a var t time.Time. Scany.Get() treats the &t as a struct with missing fields, while sqlx.Get() does write the value into the variable. Is this "by design"? I noticed this when switching from Sqlx to Scany.

[georgysavva]

Hello! This is indeed a limitation in the current scany implementation. See this comment for more details: #33 (comment)
I have plans to fix it in the future, but for now, a workaround to scan using scany would be:

type Row struct {
    T time.Time
}
row := &Row{}
if err := pgxscan.Get(ctx, pgxConn, row, "select now() as t"); err != nil {
    return nil, err
}
fmt.Println(row.T)