Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var sqlstr = `SELECT
- col1,
- col2,
- col3
- FROM public.table t1
- join public.tableb b on b.id = t1.col1
- join public.tablec c on c.id = t1.col2`
- q, err := db.Query(sqlstr)
- if err != nil {
- }
- defer q.Close()
- res = []*myStruct{}
- for q.Next() {
- info := myStruct{}
- // scan
- err = q.Scan(&info.Field1, &info.Field2, &info.Field3)
- if err != nil {
- }
- res = append(res, &bInfo)
- }
- return res, nil
Advertisement
Add Comment
Please, Sign In to add comment