Busk at 17:49, 28 December 2021

2021-12-28T17:49:45Z

Busk: Created page with "https://www.enterprisedb.com/postgres-tutorials/postgresql-query-introduction-explanation-and-50-examples"

2021-12-28T17:44:24Z

Created page with "https://www.enterprisedb.com/postgres-tutorials/postgresql-query-introduction-explanation-and-50-examples"

New page

https://www.enterprisedb.com/postgres-tutorials/postgresql-query-introduction-explanation-and-50-examples

← Older revision		Revision as of 17:49, 28 December 2021
Line 1:		Line 1:
	https://www.enterprisedb.com/postgres-tutorials/postgresql-query-introduction-explanation-and-50-examples		https://www.enterprisedb.com/postgres-tutorials/postgresql-query-introduction-explanation-and-50-examples
		+
		+
		+	```
		+	func albumsByArtist(artist string) ([]Album, error) {
		+	rows, err := db.Query("SELECT * FROM album WHERE artist = ?", artist)
		+	if err != nil {
		+	return nil, err
		+	}
		+	defer rows.Close()
		+
		+	// An album slice to hold data from returned rows.
		+	var albums []Album
		+
		+	// Loop through rows, using Scan to assign column data to struct fields.
		+	for rows.Next() {
		+	var alb Album
		+	if err := rows.Scan(&alb.ID, &alb.Title, &alb.Artist,
		+	&alb.Price, &alb.Quantity); err != nil {
		+	return albums, err
		+	}
		+	albums = append(albums, album)
		+	}
		+	if err = rows.Err(); err != nil {
		+	return albums, err
		+	}
		+	return albums, nil
		+	}
		+	```