Go Standard Library Cookbook

How to do it...

1. Run the following SQL script against your sample database:

        CREATE OR REPLACE FUNCTION format_name        (firstname Text,lastname Text,age INT) RETURNS         VARCHAR AS $$        BEGIN          RETURN trim(firstname) ||' '||trim(lastname) ||' ('||age||')';        END;        $$ LANGUAGE plpgsql;

2. Open the console and create the folder chapter08/recipe10.
3. Navigate to the directory.
4. Create the procedure.go file with the following content:

        package main        import (          "database/sql"          "fmt"          _ "github.com/go-sql-driver/mysql"          _ "github.com/lib/pq"        )        const call = "select * from format_name($1,$2,$3)"        const callMySQL = "CALL simpleproc(?)"        type Result struct {          Name string          Category int        }        func main() {          db := createConnection()          defer db.Close()          r := Result{} if err := db.QueryRow(call, ...