Method ConvertValueForLocal

contrib/drivers/pgsql/pgsql_convert.go:159–273

ConvertValueForLocal converts value to local Golang type of value according field type name from database. The parameter `fieldType` is in lower case, like: `int2`, `int4`, `int8`, `_int2`, `_int4`, `_int8`, `uuid`, `_uuid`, etc. See: https://www.postgresql.org/docs/current/datatype.html PostgreSQ

(ctx context.Context, fieldType string, fieldValue any)

//   - _date (date[]), _timestamp (timestamp[]), _timestamptz (timestamptz[])
//   - _jsonb (jsonb[]), _json (json[])
func (d *Driver) ConvertValueForLocal(ctx context.Context, fieldType string, fieldValue any) (any, error) {
	typeName, _ := gregex.ReplaceString(`\(.+\)`, "", fieldType)
	typeName = strings.ToLower(typeName)

	// Basic types are mostly handled by Core layer; handle array types and special-case bytea here.
	switch typeName {

	// []byte
	case "bytea":
		if v, ok := fieldValue.([]byte); ok {
			return v, nil
		}
		return fieldValue, nil

	// []int32
	case "_int2", "_int4":
		var result pq.Int32Array
		if err := result.Scan(fieldValue); err != nil {
			return nil, err
		}
		return []int32(result), nil

	// []int64
	case "_int8":
		var result pq.Int64Array
		if err := result.Scan(fieldValue); err != nil {
			return nil, err
		}
		return []int64(result), nil

	// []float32
	case "_float4":
		var result pq.Float32Array
		if err := result.Scan(fieldValue); err != nil {
			return nil, err
		}
		return []float32(result), nil

	// []float64
	case "_float8":
		var result pq.Float64Array
		if err := result.Scan(fieldValue); err != nil {
			return nil, err
		}
		return []float64(result), nil

	// []bool
	case "_bool":
		var result pq.BoolArray
		if err := result.Scan(fieldValue); err != nil {
			return nil, err
		}
		return []bool(result), nil

	// []string
	case "_varchar", "_text", "_char", "_bpchar":
		var result pq.StringArray
		if err := result.Scan(fieldValue); err != nil {