Stored Procedure

[ganesh-karthick]

Is it possible to get result of stored procedure via go pg? Example below, I would like to get to zoo in result model

testdb=# SELECT public.foofunction('s1','s2') as SomeColumn;
              SomeColumn               
-------------------------------------------
zoo
(1 row)

[ganesh-karthick]

This works

       var SomeColumn []string
	_, err = db.QueryOne(&SomeColumn, "SELECT foofunction(?,?) as SomeColumn", arg1,
		arg2)
	if err != nil {
		return "",err
	}
	if len(SomeColumn) == 0 {
		err == errors.New("empty rows")
		return "",err
	}
	if len(SomeColumn[0]) == 0 {
		err == errors.New("empty value")
		return "",err
	}
	return SomeColumn[0],err