weqkKuZi

1CREATE TABLE IF NOT EXISTS msg.Messages(
2    id SERIAL PRIMARY KEY,
3    content BYTEA,
4    timestamp DATE
5); 
6     
7INSERT INTO msg.Messages (content,timestamp) VALUES ('blob', 'date')
8RETURNING id; 
9     
10SELECT id, content,timestamp
11FROM msg.Messages
12WHERE id = $1 
13     
14SELECT id, content, timestamp
15FROM msg.Messages
16WHERE id > $1 
17     
18query := `
19        SELECT id, content, timestamp
20        FROM msg.Messages
21        WHERE id > $0
22    `
23
24args = 5
25query = ado.db.Rebind(query)
26rows, err := ado.db.Queryx(query, args...)
27var res []Message
28
29for rows.Next() {
30    msg := Message{}
31    err = rows.StructScan(&msg)
32    if err != nil {
33        return nil, err
34    }
35    res = append(res, msg)
36}
37
38return res, nil