Guest User

Untitled

a guest
Mar 26th, 2020
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Go 0.44 KB | None | 0 0
  1. var sqlstr = `SELECT
  2.     col1,
  3.     col2,
  4.     col3
  5.     FROM public.table t1
  6.     join public.tableb b on b.id = t1.col1
  7.     join public.tablec c on c.id = t1.col2`
  8.  
  9.     q, err := db.Query(sqlstr)
  10.     if err != nil {
  11.  
  12.     }
  13.     defer q.Close()
  14.  
  15.     res = []*myStruct{}
  16.     for q.Next() {
  17.         info := myStruct{}
  18.  
  19.         // scan
  20.         err = q.Scan(&info.Field1, &info.Field2, &info.Field3)
  21.         if err != nil {
  22.  
  23.         }
  24.  
  25.         res = append(res, &bInfo)
  26.     }
  27.  
  28.     return res, nil
Advertisement
Add Comment
Please, Sign In to add comment