[question???] How to sqlx.Select 2 values without Struct

[MushiTheMoshi]

Hi there,

First of all, really awesome work done here.

I have a quick question, can't find anywhere in the documentation how to catch a result of a sqlx.Select coming from a query
that selects 2 columns without using a struct:

//________________[ ORGS ]
func (db *DBORM) GetOrgs(Type string) (orgs []string, err error) {
	return orgs, db.Select(&orgs, `SELECT email,phone FROM "Orgs" WHERE type=$1`, Type)

I always get this ERROR:
type string with >1 columns (2)

Any help is much appreciated.

Thanks in advance,
Julio

[Nikola-Milovic]

Why dont you create a struct? And then do what you need to do with it?

func (db *DBORM) GetOrgs(Type string) ([]string, error) {
        var orgs []struct { 
          Email string  `db:"email"`
          Phone string  `db:"phone"`
}
	err := db.Select(&orgs, `SELECT email,phone FROM "Orgs" WHERE type=$1`, Type)
	return TRANSFORM ORGS TO []string, err
	

Avoid named returns and these space saving one liners